Attribute Indexing

The SQL Access database tables are created by default with a primary key and its related index. To improve data access performance, it is now possible to define and create additional indexes based on the specific needs (data aggregation and/or tables join) arising from the applications or reporting tools consuming data. Configurators may also accomplish this requirement by setting up an index on Attributes during the configuration phase. For each Attribute marked as indexed, a non-clustered index is created in SQL Server during the database creation.

All of these configuration controls are detailed under Configuration Features. Indexing does not apply when the publication occurs over PI Server tags.