Home > IT Answers > SQL Server > Clustered indexes
Satya teki
0 pts.
 Clustered indexes
SQL Server 2000
Why can only once clustered index be created on a table ? What is a row locator?

Software/Hardware used:
ASKED: October 23, 2007  10:07 AM
UPDATED: December 2, 2007  12:02 PM
RELATED QUESTIONS
Answer Wiki:
One reason is that in the old days (SQL 6.5 and before) the clustered index defined the order of the data within the table. There are other reasons out there, but this is the only one that I can think off at the moment. What do you mean by a row locator? Can you provide an example?
Last Wiki Answer Submitted:  December 2, 2007  12:02 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _