SELECT is_used FROM index_name;

where index_name is the name of the index.
and don't forget to set OCP_DBA=true in init.ora

Rgds,
Yavor

SUNIL DBA wrote:

> Hi,
> I created a ordinary index on a particular column
> (Say Emp Table - Empno Column).
> Now how I will know that whenever I'm accessing
> this table whether index in used or not where I'm
> querying based on Empno column. Is there anyway to
> check whether my index is useful or not.
>
> Bye !
>
> =====
> Sunil Kumar Ramineni,
> OCP DBA,
> India.
>
> Personal E-Mail : [Email Address Removed] __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page