Top 10 SQL server Performance tuning tips - 4

Sunday, 6 September 2009

Use of Indexes

• NON CLUSTERED index should be created on a highly selective field.
• Order of the fields in the WHERE clause should be same as the index order.
• Every table in the DB should have a CLUSTERED index.
• Primary Key may not be suitable for clustered index if the table is extensively used for SELECT.