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...
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
Which sql statement is used to return only different values?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What does the acronym acid stand for in database management?
What is sql*plus?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is the use of index in hive?
Where is pl sql used?
Can you load data into multiple tables at once? : aql loader
what happens if you no create privilege in a database? : Sql dba
What will you get by the cursor attribute sql%found?
Can we alter stored procedure?
What is data abstraction in sql?
What has stored procedures in sql and how we can use it?
How to get each name only once from an employee table?
Is sqlite thread safe?