Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Cluster
Message
From
12/09/2003 12:44:16
 
 
To
12/09/2003 12:22:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00828530
Message ID:
00828563
Views:
34
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'.
>
>
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform