What are the index designing recommendations in sql server ? Or What are the criteria for index creation in sql server ?

The main recommendation for index designing in SQL Server are as follows:

1. Analyze the where clause and sql join criteria columns in the query.

2. Use narrow indexes on the tables.

3. Analyze column uniqueness in the table.

4. Analyze the column data type.

5. Consider column order in the table.

6. Consider the type of index (Clustered Vs. Non-Clustered)

7. Prefer int data type column and primary key columns when creating the index on a table

Courtesy By : SQLServerPeoples.com