For partitioning indexes, it is recommended that you choose key columns that are unlikely to be changed.
对于分区索引,建议选择不大可能改变的键列。
These recommendations address the database schema, the choice between XML and relational storage, definition of indexes, and physical data organization with partitioning and clustering options.
这些建议涉及了数据库模式、XML与关系存储之间的选择、索引的定义以及带有分区和集群选项的物理数据组织。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
Design Advisor 非常适合为数据仓库优化数据库设计,因为除了关于索引的建议之外,它还可以提供关于 MQT、MDC 和 DPF 分区键的建议。
应用推荐