1. TARGIT Community
  2. Documentation
  3. Data Warehouse: TARGIT InMemory
  4. Import Commands

CLUSTERED INDEX

Avatar
Ole Dyring

For even more speed, it is possible to create a clustered index on one field in a table. The table will be sorted by that index, the index will be used on Range Queries or queries with multiple qualities.

Syntax:

CREATE CLUSTERED INDEX ON table_name ( field_name )

Example:

CREATE CLUSTERED INDEX ON [combined_sales] ( OrderDate )
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

See more