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
- 6794 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 do I send sql query results to excel?
What is left join in postgresql?
What are the main features of cursor?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is the source code of a program?
what are the 'mysql' command line arguments? : Sql dba
What is sql scripting?
What is rownum in sql?
What are local and global variables and their differences?
What are the different types of a subquery?
What is number function in sql?
What are tables in sql?
What is a boolean in sql?
Is there a 64 bit version of ssms?
Is pl sql a programming language?
