Wiki Markup |
---|
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 ) |