1. what is the exact use of hint in sql.
2. How we can avoid index scan in sql even though index is
there in the table.
- 1 Answers
- 6491 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / karkuvelrajan muthusamy
1. Hints instructs the optimizer to generate the explain
plan as hinted rather than the optimizer choosing its own
explain plan..
2. There are many ways like disabling the index usage by
implementing a function or an operation on the indexed
column OR giving a FULL hint in the query for that
particular table etc
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is an emotional trigger?
What is vector point function?
Is merge a dml statement?
What is pl sql package?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is the purpose of a sql?
What are tables and fields?
what is offset-fetch filter in tsql? : Transact sql
What is secondary key?
What does cursor do in sql?
What is the life of an sql statement?
How to find 3rd highest salary of an employee from the employee table in sql?
how do you login to mysql using unix shell? : Sql dba
what are the properties and different types of sub-queries? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
