clustered index

Clustered Index vs. Non-Clustered Index in SQL Server

Those new to SQL Server performance tuning or database indexes in general are probably confused by the differences between clustered and non-clustered indexes. Usually, there is a performance problem that prompts research and you finally have to "bite the bullet" and look into what the hell these index types are.

What is a Database Index?