Click here to Skip to main content
15,939,960 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
What is the use of non clustered index in table?
Posted
Updated 27-Oct-14 6:16am
v2
Comments
Herman<T>.Instance 27-Oct-14 12:03pm    
https://www.google.nl/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=what%20is%20the%20use%20of%20non%20clustered%20index%20in%20table
PIEBALDconsult 27-Oct-14 12:23pm    
You're thinking about it wrong; the better question is "what is the use of clustered index in a table".
Indices have always been around, clustered indices are a recent addition.

1 solution

From MSDN

Quote:
A nonclustered index is an index structure separate from the data stored in a table that reorders one or more selected columns


1. Nonclustered indexes can often help you find data more quickly than searching the underlying table
2. The nonclustered index can point the Database Engine to the rows in the underlying table
3. Nonclustered indexes are created to improve the performance of frequently used queries not covered by the clustered index or to locate rows in a table without a clustered index

Read more
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900