IT:AD:SQL Server:HowTo:Understand/Indexes
Summary
Developers should know the difference between:
- Heaps
- Clustered indexes
- Non-Clustered indexes
And the effect they have on retrieval (and insert speeds).
Process
Start by reading the following article: * http://www.mssqltips.com/sqlservertip/1206/understanding-sql-server-indexing/
Resources
- Clearest article I've seen yet on the subject: