467,134 Members | 920 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

Re: Clustered Indexes, what actually happens when you rebuild one, does the optimiser love them?

"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
>
Overall, I recommend that you always slap a clustered index on your
tables,
unless you have full understanding of the ramifications.
Erland,

I'm sure you mean that to be with love and care, rather than just "slap on"
any clustered index for the sake of it. :) A poorly chosen clustered index
could be worse than none at all.

--
David Portas

Nov 18 '08 #1
  • viewed: 1390
Share:
1 Reply
David Portas (RE****************************@acm.org) writes:
"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
>>
Overall, I recommend that you always slap a clustered index on your
tables,
unless you have full understanding of the ramifications.

I'm sure you mean that to be with love and care, rather than just "slap
on" any clustered index for the sake of it. :) A poorly chosen clustered
index could be worse than none at all.
Dunno. A simple-minded maintenance plan is going to clean up the mess of
a poorly selected clustered index, whereas there is not much to save a heap.

But, yes, it's certainly a good idea to select your clustered index with
some care, and not just cluster on the primary key without thinking.
Particularly not if the PK is a GUID. Then again, clustering on a GUID
does not have to be bad, as long as you specify a low fill factor, and
reindex with the same low fill factor often enough.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Nov 18 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by hrishy | last post: by
1 post views Thread by Steve_CA | last post: by
4 posts views Thread by Tryfon Gavriel | last post: by
5 posts views Thread by jim_geissman@countrywide.com | last post: by
1 post views Thread by Unregistered | last post: by
2 posts views Thread by Lyle Fairfield | last post: by
5 posts views Thread by pb648174 | last post: by
1 post views Thread by Curt | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.