Indexes don't always output in the same order
Indexing Tool : Database Engine Tuning Advisor
Indexing Tool : Database Engine Tuning Advisor
Clustered vs non clustered index
from http://www.programmerinterview.com/index.php/database-sql/clustered-vs-non-clustered-index/ What is the difference between a Clustered and Non Clustered Index? A clustered index determines the order in which the rows of a table are stored on disk. If a table has a clustered index, then the rows of that table will be stored on disk in the same exact order as the... Continue Reading →