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
- 5919 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between a local and a global temporary table? : Sql dba
What is vector point function?
What are pl sql data types?
Why is a primary key important?
What is a table in a database?
What is the difference between union and union all command?
What is structural independence and why is it important?
What does t sql mean?
Can 2 queries be executed simultaneously in a distributed database system?
What is oracle pl sql developer?
What are secondary keys?
What is substitution variable in pl sql?
what are dynamic queries in t-sql? : Transact sql
Why is a trigger used?
What is application trigger?
