Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Combination of column index Expand / Collapse
Author
Message
Posted Wednesday, April 22, 2009 12:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 12, 2009 4:15 AM
Points: 21, Visits: 31
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
Post #702079
Posted Wednesday, April 22, 2009 4:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:30 PM
Points: 14,802, Visits: 27,275
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. 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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #702175
Posted Wednesday, April 22, 2009 10:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:20 PM
Points: 41,529, Visits: 34,445
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #702516
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse