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


Picture showing the graphical representation of the 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)

Posted By  -  Karan Gupta
Posted On  -  Wednesday, January 28, 2015


Your Email Id  
Query/FeedbackCharacters remaining 250