IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
IDS now automatically collects index statistics on the leading index key while the index is being created.
该命令的输出会展示出每个分区的数据和索引统计信息,并针对需要重组的分区提供建议。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
本例中,10%的表数据页用于表统计信息的收集,而对于索引统计信息,将使用所有的索引页。
In this example, 10 percent of table data pages are used for the collection of table statistics, while for index statistics all of the index pages will be used.
应用推荐