Re: Clustered Indexes

2004-01-02 Thread Chris Nolan
alues on the ordered attribute AND you put the effort into ensuring that the table's ordering characteristic didn't change much. Regards, Chris On Sat, 2004-01-03 at 09:50, Casey Sheridan wrote: > In MS SQL Server 2000, it is possible to create what MS refers to as > "clustered i

Clustered Indexes

2004-01-02 Thread Casey Sheridan
In MS SQL Server 2000, it is possible to create what MS refers to as "clustered indexes." You can have only one clustered index per table, because the index is created by sorting the entire table by the row that is to be the clustered index. If you have a table with a row called &quo