Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clustered Index
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
00705479
Message ID:
00705501
Views:
9
The clustered index is the most powerful index that is available to you. Actually, the clustered index does not provide as much overhead as non-clustered indexes. The leaf-level nodes of the clustered index makeup the table. An clustered index traversal requires one less page IO then a non-clustered traversal because of this.

-Mike

>Hi.
>
>Is the clustered index overhead for table data entry something considerable ?
>
>Thanks.
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform