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'.


cheers

>hello Jim
>
>what exactly is a clustered index?
>
>>While I think the VFP Team could, I'd have to ask why it should?
>>
>>I see little benefit and LOTS of potential trouble with doing so. Sometimes "nifty" ideas are just that - ideas... and sould be left that way.
>>I'd bet that a clustered index is something that the SQL group could happily do without.
>>
>>Just one opinion.
>>
>>>Well !!
>>>
>>>In the Fox it has as to create Cluster Index ?
>>>
>>>Thank all
>>>
>>>Lázaro Santos.