Proper indexing in SQL Server is extremely important for application performance. Here are some common design guidelines for choosing the right index setup:
- A clustered index is used on fields that increase continuously, e.g., auto number integer fields. Because SQL Server physically arranges rows in the database file based on a clustered index field, if I choose some fields that do not continuously increase, it will be rearrange too many pages during the INSERT and DELETE steps.
- Foreign key fields are non clustered index types because they are not added as increasing values.
18fb2067-76b9-4951-9191-4e450c57f8ee|0|.0
indexing