Supports temporary, regular and partitioned tables of different types of range and list.
支持临时表、常规表以及范围和列表类型的分区表。
This usually points to a poorly designed data model or irregularly partitioned tables.
数字表名一般特指失败的数据设计模型或者非常规表。
In a multi-partition environment, you can have single-partition tables or multi-partitioned tables.
在多分区的环境中,可能具有单分区的表和多分区的表。
For example, NDB storage engine supports partitioned tables and memory engine supports in-memory tables.
例如,NDB存储引擎支持分区表,内存引擎支持内存表。
I have a table structure with partitioned tables, where a few child tables inherit from a common parent.
我与分区表有一个表的结构,其中一些孩子继承了一个共同的父表。
Full text search of data in range-partitioned tables using the Net search Extender (NSE) is now available.
现在,可以使用NetSearchExtender (nse)对范围分区表进行全文搜索。
I also described two ways to use the partition BY clause of the create table statement to create partitioned tables.
我还描述了使用CREATETABLE的PARTITIONBY子句来创建分区表的两种方法。
Supports user, temporary, regular and partitioned tables of different types range, hash and multidimensional clusters.
支持用户表、临时表、常规表以及范围、哈希和多维簇类型的分区表。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATEtable语句决定,而不是由CREATEindex语句决定。
I have a table structure with partitioned tables, where a few child tables inherit from a common parent. How so I DELETE only from the parent table?
我与分区表有一个表的结构,其中一些孩子继承了一个共同的父表。我怎么DELETE只有从父表?
The purpose of this example is to show that when dealing with partitioned tables, you need to account for the number of partitions from the operator output stream.
这个例子的意图是说明,在处理分区的表时,需要考虑到操作输出流涉及的分区数量。
In this column, I'll show you how to create partitioned tables, and I'll show you how a partitioned table's definition determines where individual records are stored.
在这篇专栏文章中,我将讨论如何创建分区表,解释分区表的定义如何决定各个记录的存储位置。
Media preference could be controlled at the partition (member level) for SQL partitioned tables, but the same was not possible for DDS-created physical files with multiple members.
对于已分区的sql表来说,媒介首选项可以在分区(成员)级别进行控制,但是对于具有多个成员的DDS创建的物理文件则无法实现这一点。
Another advantage of using partitioned tables is that new data can be easily added to a table (as another data partition) while old or obsolete data can be easily removed and archived.
使用分区表的另一个优点是,可以轻松地在表中添加新数据(作为新的数据分区),同时可以轻松地删除并存档老数据。
Tables within a partitioned database can be located in one or more database partitions.
在分区数据库中,一个表可以分布在一个或多个数据库分区中。
The catalog tables for partitioned databases reside only on the partition from which the CREATE database command was issued.
分区数据库的编目表只存储在发出CREATEDATABASE命令时所在的那个分区上。
If dependents such as staging tables or refresh immediate MQTs exist on the partitioned table, the second phase starts automatically after these dependents are refreshed via SET INTEGRITY.
如果在已分区表上存在类似临时表或者立即刷新MQTs之类的依赖表,第二阶段会在利用SETINTEGRITY刷新了这些依赖表后自动启动。
When lookup tables are used in joins with other large partitioned table spaces, you can maximize the parallelism in the join by partitioning the lookup tables as well.
当将查找(lookup)表与其他较大的分区的表相连接时,通过将查找表也进行分区,可以最大化并行度。
Since DB2 z/OS utilities run at either table space level or partition level for partitioned-table space, they would affect all tables present in the table space.
由于DB2z/OS实用程序在分区表空间的表空间级或分区级运行,所以它们会影响表空间中存在的所有表。
Database partition 0 is typically used for storing small, non-partitioned lookup tables.
数据库分区0通常用于存储小型的非分区的查找表。
WebSphere Information Integrator does not support system-maintained materialized query tables that reference nicknames in a partitioned database environment.
WebSphereInformation Integrator不支持在分区数据库环境中引用昵称的系统管理的物化查询表。
Partitioning enhancements allow tables and indexes to be better partitioned for performance.
分区增强允许表和索引为性能更好的分区。
Partitioning enhancements allow tables and indexes to be better partitioned for performance.
分区增强允许表和索引为性能更好的分区。
应用推荐