Re: Finding unused indexes

From: Van Messner <vmessner_at_netaxis.com>
Date: Fri, 7 May 1999 19:53:21 -0400
Message-ID: <C7LY2.4487$fO5.190970@news14.ispnews.com>

You could search for indexes with a very low selectivity ratio. Chances are if you're using the cost-based optimizer those indexes are never used.

Van

jimharte_at_my-dejanews.com wrote in message <7gvc01$nbo$1_at_nnrp1.deja.com>...
>Does anyone know of a way to find indexes that are never/rarely used in an
>Oracle database? Our company's DBA is reluctant to add any more indexes to
>our production database. I've just developed new features in our
application
>that require additional indexes for performance. I figure maybe I can make
a
>better argument for adding indexes if I can point out others that can be
>dropped. Does Oracle keep stats on index usage?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri May 07 1999 - 18:53:21 CDT