You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

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 )

  • No labels