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
- 6857 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
how to drop an existing index in mysql? : Sql dba
What is pls integer?
How long it takes to learn pl sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
what are the different tables present in mysql? : Sql dba
what are sequences
how to rename an existing column in a table? : Sql dba
What are the uses of merge?
Can instead of triggers be used to fire once for each statement on a view?
What are the different parts of a package?
what is the difference between blob and text? : Sql dba
How do I start pl sql?
what are the types of join and explain each? : Sql dba
how many sql ddl commands are supported by 'mysql'? : Sql dba
