Re: Missing Index entries

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Wed, 30 Jun 2004 21:50:54 +0100
Message-ID: <sBGEc.647$LK1.104@newsfe6-win>

"Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message news:40e31edf_at_post.usenet.com...
> **** 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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

I know myself which indexes are broken really, but i want them to diagnose the problem and tell me why its happening Received on Wed Jun 30 2004 - 15:50:54 CDT