How to tell what index tags are actually used

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Fri, 3 Dec 2004 08:29:57 -0500

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

  • Re: .NET anger.
    ... course, who get to sell to coders), the end user really doesnt care. ... ..net that cant be done in a native app - usually faster, ... know much about the automatic garbage-collection, rich type system, ...
    (borland.public.delphi.non-technical)
  • Re: need kestroke logger source code - will pay $$$ for it....
    ... > i need and will pay for a simple app that logs keystrokes, ... > coders... ... but will another lang allow that?) ...
    (comp.security.misc)