Clustered Nuts?

While looking at performance in some of my databases, I noticed there was a high number of FreeSpace scans going on.   Aaargh!  They are called clustered indexes, people use them!  Performance, performance, performance!

In most cases it is best practices to start with a clustered index on every table created.  There are rare instances when this is not the optimal setup, but for the large majority of standard databases put in a clustered index on each table.  Your shooting yourself in the foot, people!



About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on February 21, 2012, in Database Administration Tasks and tagged , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: