By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

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

P: n/a
"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
Share this Question
Share on Google+
1 Reply


P: n/a
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.