These key optimizer statistics are maintained in Adaptive Server:
Statistics per partition: table row count; table page count. An unpartitioned table is considered to have one partition for the purposes of the systabstats catalog. Can be found in systabstats.
Statistics per index: index row count; index height; index leaf page count. A local index has a separate systabstats row for each index partition. A global index, which is considered a partitioned index with one partition, has one systabstats row. Can be found in systabstats.
Statistics per column: data distribution. Can be found in sysstatistics.
Statistics per group of columns: density information. Can be found in sysstatistics.
Statistics per partition
Column statistics: data distribution per column; density per group of columns. Can be found in sysstatistics.
