March 10, 2009 at 5:49 am
Hi.. I am new to Index in SQL Server. Pls provide some info about
When to use Clustered Index & Non-Clustered Index?
What are the advantages & dis advantages of Clustered Index?
What are the advantages & dis advantages of Non-Clustered Index?
Thanks
March 10, 2009 at 7:22 am
Have you looked in Books On Line?
A few general rules of thumb (and remember in SQL Server everything comes with an "It depends" attached):
1. Every table should have a clustered index.
2. The clustered index should be on a monotonically increasing value because the index IS the leaf level of the data (the data is physically stored in this order).
3. The clustered index key should be narrow because the clustered index is included in the non-clustered indexes.
4. Clustered indexes tend to be better for range queries while non-clustered indexes tend to perform better for equality queries.
Here's a link to a list blog posts by Gail Shaw (gilamonster here on SSC) that provide good index information:
http://sqlinthewild.co.za/index.php/category/sql-server/indexes/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 12, 2009 at 4:50 am
http://msdn.microsoft.com/en-us/library/aa174523(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspx
go through these..........;)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply