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)





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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250