« SQL Agent Job Reporting - alerts for jobs that haven't ran for a while | Main | Scheduling SQL statements in the future »
Friday
Feb082013

Get Overview of Indexes on a Table

SSMS is always giving me index suggestions for slow queries , but doesn't take into account anything else running on the system, how useful the index would be beyond just that query, or whether there's an existing index that would do a "good enough" job with substantially less upkeep.
    Before adding indexes I have to remember:
  • Is there an existing index with the same left edge key column(s)?
  • What columns are included in the leaf level?
  • Could I tweak existing indexes to take advantage of index intersection?
I'll need to revisit this because the display format is not...quite right, but it sure beats going into index properties in Object Explorer.

 

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>