Creating Indexes
Creating Indexes
Vector does not rely on explicitly created indexes to achieve good performance. Most reporting and data analysis workloads do not benefit from indexed tables.
Workloads that may benefit from indexed data include:
• Highly selective filter queries on large tables
• Single row UPDATE or DELETE statements
Primary (clustered) and secondary indexes can be created for Vector tables.
Last modified date: 12/19/2024