Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL SERVER- Non-Clustered Index

Posted on 2013-06-13
1
Medium Priority
?
548 Views
Last Modified: 2013-06-13
Are the Non-Clustered indexes stored physically in order by the index? Or are they inserted into the index table in order of their creation?

1 2 3 4 5 6 7 .....
or
1 5 4 7 6 .......
0
Comment
Question by:metro156
1 Comment
 
LVL 49

Accepted Solution

by:
PortletPaul earned 2000 total points
ID: 39246393
A nonclustered index can be defined on a table or view with a clustered index or on a heap. Each index row in the nonclustered index contains the nonclustered key value and a row locator. This locator points to the data row in the clustered index or heap having the key value. The rows in the index are stored in the order of the index key values, but the data rows are not guaranteed to be in any particular order unless a clustered index is created on the table.
http://msdn.microsoft.com/en-us/library/ms175049.aspx
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question