Posted by SQLpro [MVP] on 06/18/37 11:43

Erland Sommarskog a écrit :
> Doug (drmiller100@hotmail.com) writes:
>> hmmm.
>> "always have a clustered index"?????
>>
>> Why? IMO, clustered indexes are a bad idea for most tables.
>
> Arguments? Or is it just an opinion?
>
take a look over Kimberly's paper about that.
You will see that CLUSTERED index is good for :
- monotonically growing index value
- monocolumn index
- no update to vartype data

A +


--
Frédéric BROUARD, MVP SQL Server, expert bases de données et langage SQL
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
********************* http://www.datasapiens.com ***********************

• Next in forum: Re: Where to write XQuery statements?
• Prev in forum: Re: Help selecting an alias
• Thread view: Re: slow insert, logical fragmentation

[Reply to this message]