Spotfire Ideas Portal
Indexes are created when creating a cache table with multiple tables when an index label is assigned to the view when the cache table is created.
However, when creating a cache table for a single table, the index is not created.
There must be situations where indexes are needed even for a single-table cache.
Adding an index to a single table cache comes with certain limitations. First, it cannot be a unique index as, by design, the cache table hosts multiple data snapshots. Second, the presence of the index has an adverse impact on the performance of loading new snapshots.
In fact, the above limitations were part of the reasons multi-table caching was introduced. Multi-table caching offers support for indexing and is the recommended caching mode to use.