Re: Unused indexes

Simple script for potentially superfluous indexes

select table_owner, table_name ,column_name from all_ind_columns  where column_position =1
 group by table_owner, table_name , column_name having count(*) > 1;

Gary Waldrom

-----Original Message-----
From: akolk - gelrevision.nl [mailto:akolk_at_gelrevision.nl] Posted At: 25 November 1999 09:25
Posted To: server
Conversation: Unused indexes
Subject: Re: Unused indexes

This only works for Oracle8 ! Not 7.3

Anjo.

Connor McDonald wrote:

> Boris Oblak wrote:
> >
> > Hi,
> >
> > How can i found unused or inefficient indexes on Oracle 7.3 or
Oracle8?
> >
> > Thanks,
> > Boris
> >
> > e-mail:boris.oblak_at_k2.net
>
> You could always scan x$bh at period intervals, join to OBJ$ for
TYPE#=1
> which will tell you what indexes are in the buffer cache...
>
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Fri Nov 26 1999 - 03:01:36 CST