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
- 6491 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 to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
How does one use sql*loader to load images, sound clips and documents? : aql loader
what are the differences between require and include, include_once and require_once? : Sql dba
What is difference between db2 and sql?
What are all the different normalizations?
Does access use sql?
How to select all records from the table?
What is the use of <> sql?
What are operators available in sql?
How exception handling is done in advance pl/sql?
what is a field in a database ? : Sql dba
How to rename a column in the output of sql query?
What is synchronized subquery?
How do I remove sql developer from windows 10?
what is the different between now() and current_date()? : Sql dba
