Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6520 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
what is top in tsql? : Transact sql
How many commands are in sql?
What is embedded sql in db2?
Is it possible to create the following trigger: before or after update trigger for each row?
What is a mutating table and a constraining table?
How run sql*plus commands that are stored in a local file?
how can we optimize or increase the speed of a mysql select query? : Sql dba
How can I speed up sql query?
What is dba in sql? : SQL DBA
Which one is better sql or oracle?
Can I learn sql in a week?
how can we find the number of rows in a table using mysql? : Sql dba
what are date and time functions in mysql? : Sql dba
What company owns postgresql?
What is embedded sql what are its advantages?
