Re: How to tell what index tags are actually used

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jeff Grippe (jgrippe_at_hilldun.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 08:32:06 -0500

Actually those aren't the ones that are hard to find. A grep through the
code picks up the ones that are a result of coding. The ones that are harder
to find are the ones that were created to optimize report and query
generation.

Thanks
"tom knauf" <tom.knauf@itds.de> wrote in message
news:cp42og$24d$05$1@news.t-online.com...
> Hi,
>
> I would add a small application method oapp.logit() which "Echos" (Set
> alter
> to or so) ALIAS() , Key() and TAG() into a logfile and place calls to
> this
> method allover the programs. Then just let the users use it for some days
> und put the textfile into excel and sort/filter it. I would not use a dbf
> for it to prevent sideeffects, just produce a textfile.
> May be you put asserts into it but then you have to use it by yourself.
>
> HTH
> Tom
>
>
> "Jeff Grippe" <jgrippe@hilldun.com> schrieb im Newsbeitrag
> news:10r0q71gjh883a3@news.supernews.com...
>> Hello all and thank in advance for the help.
>>
>> I have an app that I maintain which I inherited from other coders. There
> are
>> some tables for which over 50 index tags have been created and I'm
>> certain
>> that not all of them are needed. I can certainly tell which ones are
>> referred to in the code by searching for all of the instances of SET
>> ORDER
>> in the project but that still leaves me with over 30 that may be
>> unnecessary.
>>
>> Is there anything I can turn on that is similar to profiling that will
> tell
>> me which indexes actually get used?
>>
>> I suppose that I could always remove them one at a time and see if anyone
>> complains that their report or query has gotten really slow but I would
>> prefer a more intelligent approach.
>>
>> Does anyone have any ideas?
>>
>> Thanks again.
>>
>> Jeff
>>
>>
>
>

Relevant Pages

  • Temp table from text file connected via Linked Server
    ... I have a text file as a table in a linked server. ... statement to query the file, changing the name of the file. ... SELECT TextFile.* ... DECLARE @strFileName varchar ...
    (microsoft.public.sqlserver.programming)
  • Data Driven Query - Lookup where Clause
    ... im trying to write a lookup query for a Data driven Query. ... Im having problems with one part of the query which is in the 'where' clause. ... im trying to compare a string value from a text file to a smalldatetime value. ... Ive tried converting the textfile value to '27/02/2004' but am getting nowhere ...
    (microsoft.public.sqlserver.dts)