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
- 6940 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 the difference between the repeatable read and serializable isolation levels? : Transact sql
how to present a past time in hours, minutes and seconds? : Sql dba
How can a pl sql block be executed?
What are packages in pl sql and also explain its advantages?
What is the process of copying data from table a to table b?
Which nosql database is best?
Which is better join or inner query?
Do prepared statements prevent sql injection?
How do I view a view in sql?
What is the purpose of my sql?
What is difference between inner join and cross join?
Which kind of parameters cannot have a default value in pl sql?
Can variables be used in sql statements?
What is the difference between numeric and autonumber?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
