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
- 6726 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
Why truncate is used in sql?
Is join same as left join?
What is partition in sql query?
What is user in sql?
What is the difference between the sql*loader and import utilities? : aql loader
how to dump a table to a file with 'mysqldump'? : Sql dba
What is insert command in sql?
What is raid? How does it help storage of databases?
What is a join query?
How many tables can you join in sql?
What is the difference between rollback and rollback to statements?
Can we call a function containing dml statements in a select query?
What is the purpose of my sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is normalization in a database?
