Re: Missing Index entries

• Post for FREE via your newsreader at post.usenet.com ****

Hi Dave

> My next question was which index is broken (as there are a few which could
> satisfy my query) i dont want to blindly rebuild 11 indexes on 110 Million
> row table.

If the execution plan you can see which index is used.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=