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

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

More SQL PLSQL Interview Questions

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,


Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  


Explain scalar functions in sql?

0 Answers  


What is cost in sql execution plan?

0 Answers  


What is the purpose of design view?

0 Answers  


hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  


what are the different type of normalization? : Sql dba

0 Answers  


Main diff between varray and nested tablea

3 Answers   Polaris, TCS,


what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  


What does pl sql stand for?

0 Answers  


What does varchar include?

0 Answers  


What is acid property in a database?

0 Answers  


Categories