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

Optimization article:

http://www.sqlusa.com/articles/query-optimization/

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

CI is assigned to PRIMARY KEY by default. Range search may require CI support. CI can be shifted away from PK

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

???

---

Kalman Toth Database & OLAP Architect sqlusa.com

New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012