From: "Ken Shan" <kenxuauh@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Auditing on using indexes
Date: Wed, 8 Aug 2001 22:25:28 +0800
Organization: IMS Netvigator
Lines: 9
Message-ID: <9kricm$t383@imsp212.netvigator.com>
NNTP-Posting-Host: pcd277219.netvigator.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


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