I am creating an index on Emp table Empno column,if u using this indexed colum

I am creating an index on Emp table Empno column,if u using
this indexed column in ur SELECT stmt. where clause,then how
do u know that yr index will be working or nor?
Thanks Advance...

Question Posted / ajit

3 Answers
6015 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt...

Answer / satish

Do the explain plan.if it is not using ur created index
then use hints to use ur created index

Is This Answer Correct ?

6 Yes

0 No

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt...

Answer / suresh ramsing

You execute your query like
explain plan for select sal from emp where empno='1224';
after that check this below one.
select * from table(dbms_xplan.display);
here u can find it'll be excuted by using index or TABLE ACCESS FULL

Is This Answer Correct ?

4 Yes

0 No

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt...

Answer / manoranjan sethy

by using SET AUTOTRACE ON EXPLAIN tool you can came to know weather such index is working or not.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer