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
- 6601 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 many clustered indexes can be created on a table?
Is sql a oracle?
What are the steps for performance tuning.
How many sql statements are used?
What are two statement types in sql?
What does the file extension accdb stand for?
What does bitemporal mean?
Is sqlite good enough for production?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is structural independence and why is it important?
define join and explain different type of joins? : Sql dba
What is linq to sql?
What does a pl/sql package consist of?
Is left join same as join?
How to revise and re-run the last sql command?
