Open topic with navigation
Lists distinct counts and average key sizes for prefixes of index keys for all the indexes on persistent tables in the database.
Client applications should never contain code that accesses
SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|OBJECTID||integer||The database object ID for the index|
|CATALOGID||integer||The database catalog ID for the index|
|PREFIXLENGTH||integer||The number of index key columns that this particular distinct count is valid for|
|DISTINCTCOUNT||bigint||An estimate of the number of distinct values with that prefix|
|AVERAGEKEYLENGTH||double||Average key size for the keys whose prefix count is given in this row|
See Example under
SYSTEM.INDEXSTATISTICS (INDEXSTATISTICS System Table Description).