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
- 6722 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
How do you take the union of two tables in sql?
How is a PL/SQL code compiled?
What does rownum mean in sql?
what are properties of a transaction? : Sql dba
How do you create a unique index?
What is the use of index in hive?
Why join is faster than subquery?
How do I install sql?
What are all the different normalizations?
Does sql*plus also have a pl/sql engine?
What are the 3 modes of parameter?
What is foreign key in sql with example?
what is the stuff function and how does it differ from the replace function? : Sql dba
Explain the difference between drop and truncate commands in sql?
Can we rename a column in the output of sql query?
