No, it's not. The data appears physicaly sorted but it isn't stored this way internaly.
>hmm, isn't that then like a continues 'sort to' command from fox?
>
>
>>At least for SQL Server, a clustered index, simply put, is an 'index' (one only) where the data is physically stored in the correct index order AND the index is in the leaf node WITH THE DATA.
>>
>>Since data can be **physically** ordered by only 1 index, there can be only 1 clustered index per table. The table can have oodles of other indexes.
>>
>>
>>Gotta be a real bear to 'maintain'.
>>
>>
--sb--