Thanks Mike.
Should all my tables have a clustered index ? Are there cases where I should avoid this ?
Obrigado.
Ivan
>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.
Ivan