From: "Chuck Hamilton" Newsgroups: comp.databases.oracle.server Subject: Re: Auditing on using indexes Date: Wed, 8 Aug 2001 11:24:06 -0400 Lines: 20 Message-ID: <9krlip$67ebi$1@ID-85580.news.dfncis.de> References: <9kricm$t383@imsp212.netvigator.com> NNTP-Posting-Host: 207.140.171.61 X-Trace: fu-berlin.de 997284249 6535538 207.140.171.61 (16 [85580]) X-Newsreader: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 "Ken Shan" wrote in message news:9kricm$t383@imsp212.netvigator.com... : Hi there, : : There are many indexes created on our database, but how can I know which : indexes are used by the SQLs or which indexes are no longer used ? Is there : any ulitilities or tools ? thanks : : Ken : : The tuning pack includes a tool called "tuning expert" or something like that which will tell you which indexes are being used. If you don't want to buy that, you'll need to monitor the SQL area of the shared pool and capture all sql that's using the table (don't forget views too), and run an explain plan on each to see if the index is being used.