spotlight_stat_keys contains key values for all of the collections stored in the Spotlight Statistics Repository. Each key value/table/data source combination has a row in this table. The purpose of this table is to allow queries to get data from the fact table based on a key value without having to scan values in the fact table itself.
Column | Description |
---|---|
statistic_key_id |
Generated ID. |
statistic_class_id |
The statistic_class (Collection) this column belongs to. |
datasource_id |
The data source of the collection that this column belongs to. |
statistic_name_id |
Generated ID. |
statistic_key_name |
The name of the key column. |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy