Cluster Indexes: It is created on clustered tables.
聚类指标:它是在聚集表创建。
Indexed views have the same storage structure as clustered tables.
索引视图与聚集表具有相同的存储结构。
Not supported are range clustered tables (RCT), materialized query tables (MQT), and typed tables.
不支持范围簇表(RCT)、物化查询表(MQT)和有类型的表。
DB2 V8.2.2 enhances Range Clustered tables (RCTs), first introduced in V8.1.4, with a percent-free option that you can use with regular DB2 tables.
DB 2V8.2.2enhancesRangeClustered Table (RCT)最先是在V8.1.4中引入的,带有一个percent - free选项,该选项可用于常规的db2表。
If the table in your query are pretty small (usually fewer than 1,000 rows) or clustered tables, and your query is not selective at all, it would be beneficial to use a table scan.
如果查询中的表极其小(通常少于1,000行)或者是群集表,而且查询根本没有选择性的话,那么使用表扫描会更好一些。
Never fire-up a non-clustered instance against the same set of tables that any other instance is running against.
永不火了一个非群集对同一套表格,例如,任何其他实例正在运行反对。
Never fire-up a non-clustered instance against the same set of tables that any other instance is running against.
永不火了一个非群集对同一套表格,例如,任何其他实例正在运行反对。
应用推荐