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
- 6467 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 does sign mean sql?
Where not exists in sql?
Can we use two order by clause in query?
What is the difference among union, minus and intersect?
what are the different type of normalization? : Sql dba
How do I make sql search faster?
How do I save the results of sql query in a file?
how to drop an existing table in mysql? : Sql dba
what is user defined functions? : Sql dba
How many indexes can be created on a table in sql?
What are three advantages to using sql?
Explain exception handling in pl/sql?
What is union?
What are the 3 modes of parameter?
what are rollup and cube in t-sql? : Transact sql
