April 22, 2009 at 12:58 am
hi forum
How can the DBA identifies what index need to create on a particular table, how can we analyse to create a combination of column index?
manz
April 22, 2009 at 4:20 am
That's a huge topic. There have been books written about it (note the bottom of this post 😀 ). Which indexes you place on the tables really depends largely on how the data is going to be retrieved, meaning, what kind of queries are written against it.
An entire book might be a bit much. Gail Shaw has recently written a couple of good articles over at Simple-Talk on how to identify poor performing procedures[/url]. Once you know what's running slowly, you can usually figure out where to put your indexes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2009 at 10:27 am
Grant Fritchey (4/22/2009)
That's a huge topic. There have been books written about it (note the bottom of this post 😀 ).
Not enough books, unfortunately. I'd love to have a definitive book on indexing (and just indexing) that I could refer people to.
Manz, you may also benefit from two blog posts that I wrote.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply