Good Questions ???

-----Original Message-----
From: Shivsagar [mailto:[Email Address Removed]
Sent: Friday, May 30, 2003 3:10 AM
To: LazyDBA.com Discussion
Subject: Re: Is My Index is Using by Table or not?

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


Oracle LazyDBA home page