Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

spotlight_stat_keys

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating