Indexes in SQL Server

Index is one of the SQL Server object. Mainly indexes are used to improve the performance of the  queries.Indexes are created on any tables or views.

Mainly there are two types of indexes.

  1. Clustered Index
  2. Non-Clustered  Index.


  • Only one clustered Index is permitted per table or view.
  • We can create multiple non-clustered indexes on a table or view.(In SQL Server 2005 {249}, From SQL Server 2008 on words max limit is: {999} ).


To get more information click on below link.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s