Non Clustered Index in SQL Server(dotnetvj.com)
submitted by 
Kadiyalavj(580) 3 years ago
In my previous article on "Clustered Index in SQL Server" we talked about creating a Clustered Index. In this article we will talk about creating a Non-Clustered Index.
Non Clustered Index:
Non Clustered index is a separate object. This doesn’t depend on how the data is stored in the table. So you can have more the one index on a table.
When you create a primary key on any table by default SQL Server creates the clustered index. To avoid this you need to use NONCLUSTERED keyword in the primary key creation script.
|category: Database
|Views: 17
tags:
Vijaya_Kadiyala dotnetvj Database another
Everyones tags:
Your Tags: