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
6464 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

Can we join two tables without common column?

928

How to get unique records from a table?

896

What does (+) mean in sql joins?

1006

what are set operators in sql? : Sql dba

982

Explain the difference between sql and mysql.

1000

What is full join?

895

Explain polymorphism in pl/sql.

1055

What is compilation error in pl sql?

920

explain mysql aggregate functions. : Sql dba

939

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

904

What do you mean by query optimization?

949

What are the ddl commands?

947

What is the difference between unique and primary key constraints?

1005

What does select top 1 do in sql?

994

Can we create view in stored procedure?

908