Referenced Columns
Many of the Data Dictionary view columns have referenced table columns. That is, the value in the view column corresponds to a value in the selected column referenced in the table. It would be meaningful to join the view and the referenced table based on the selected column and the referenced column.
Referenced columns for this view are:
View Column | Referenced Column |
---|---|
IndexNumber | DBC.Indexes.IndexNumber |
IndexNumber
The IndexNumber field contains the index number when statistics are collected on an index. Otherwise, it is NULL.
MaxInterval and MaxValueLength
If these statistics are collected with system determined maximum intervals and maximum value length, the MaxInterval and MaxValueLength columns are NULL.
SampleSizePct
If sampling is not used, the SampleSizePct column is set to 0 or 100.
StatsSource
The StatsSource column records the method by which this statistic is acquired. For information about the possible values for the StatsSource column, see "StatsSource Column."