... FOR COLUMNS:只统计某个字段 FOR ALL COLUMNS:统计所有字段 FOR ALL INDEXED COLUMNS:统计索引的所有字段,如 ...
基于6个网页-相关网页
FOR ALL INDEXED COLUMNS 统计索引的所有字段
Also use it for all columns that are not the leading column of any index.
对于不是索引起始列的所有列,也应使用该模式。
The statistics are collected for all columns (with distributions) and all indexes (with extended statistics).
统计信息是从所有列(带有分布信息)和所有索引(带有扩展的统计信息)上收集的。
If, in addition, distribution statistics (frequency and quantile statistics) should be collected for all columns of the table CARS, execute the following command.
此外,如果需要收集CARS表中所有列的分布统计信息(频率统计信息和分位数统计信息),那么可以执行以下命令。
应用推荐