Articles → SQL SERVER → Indexes in SQL server
Indexes in SQL server
What do I need on my system?
What are technical concepts I need to know?
What is a database index?
Types of database index in SQL server
How physical sorting and logical sorting are different
B-Tree
Click to Enlarge
Cluster index
-- Syntax for creating clustered index
CREATE CLUSTERED INDEX index_name ON table_name (column_name)
Non-Clustered index
-- Syntax for creating non clustered index
CREATE NONCLUSTERED INDEX index_name ON table_name (column_name)