Database Administrator Guide > Database Administrator Guide > Creating Indexes for X100 Tables
Was this helpful?
Creating Indexes for X100 Tables
 
Indexes in X100
Create a Primary (Clustered) Index
Creating a Secondary Index
Secondary Indexes with Joins
Indexes in X100
X100 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 X100 tables.
Last modified date: 11/09/2022