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...
- 3 Answers
- 5934 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to shut down the server with 'mysqladmin'? : Sql dba
How to run sql functions in pl/sql?
What is the process of copying data from table a to table b?
Why triggers are used?
What port does sql server use?
What is indexes?
What is primary key and foreign key?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What are the features of pl sql?
Is sql better than access?
How do you create a unique index?
What is the plv (pl/vision) package offers?
Which is faster truncate or drop?
What are sql objects?
What kind of join is join?
