Post reply

how to optimize store procedure and findout missing index on table

  • March 31, 2007 at 9:52 pm

    #194991

    hello

     

    how to find out missing index on table

  • April 1, 2007 at 9:43 am

    #698004

    How do you know an index is missing? What are you looking to do?

    The question doesn't make sense by itself. There are not any "missing" indexes without some reason being there for their existence.

  • April 9, 2007 at 6:09 am

    #699287

     

    I think he is trying to ask how would he know if he needs an index.

    Answer being, analyze the execution plan, it is your most effective way for determining whether or not you need an index. Make the index, then re-analyze the execution plan, you may find that the index is not the answer to your problem. I would not trust using the indexing wizard. 

  • April 11, 2007 at 3:54 pm

    #699923

    Add a query or workload to query analyzer, and run the index tuning wizard

    Dan Pitta

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply