by using SET AUTOTRACE ON EXPLAIN tool you can came to know weather such in

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 / manoranjan sethy

3 Answers
6625 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How do I get sql certification?

976

What is the difference between sql and mysql?

1124

What is synchronized subquery?

1173

Is record in pl sql?

980

Are stored procedures faster than dynamic sql?

1047

How to run pl/sql statements in sql*plus?

1084

Why query optimization is needed?

930

What is bind variable in pl sql?

1059

Can we create view in stored procedure?

981

What do you know by pl/sql cursors?

1110

what is the use of friend function? : Sql dba

1025

What is a crud api?

956

explain the delete statements in sql

1065

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1089

what are the differences between require and include, include_once and require_once? : Sql dba

1029