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] you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page