Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6875 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
Is id a reserved word in sql?
Why having clause is used in sql?
Is foreign key mandatory?
what are the disadvantages of mysql? : Sql dba
What is a nested table in word?
What sql database should I use?
What are all types of user defined functions?
Enlist the data types that can be used in pl/sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
What can I use instead of union in sql?
What is function and procedure in pl sql?
What is the difference between mdf and ndf files?
Whis is not false in primary key?
Why is normalization important?
What are triggers and its uses?
