Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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