How about EXPLAIN PLAN?


>From: "Shivsagar" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: Is My Index is Using by Table or not?
>Date: Fri, 30 May 2003 15:40:15 +0530
>
>Are you really an OCP DBA?
>just curios......
>
>----- Original Message -----
>From: "SUNIL DBA" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, May 30, 2003 3:33 PM
>Subject: Is My Index is Using by Table or not?
>
>
> > 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 documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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
>

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

Oracle LazyDBA home page