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
- 6886 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 t-sql? : Transact sql
Does inner join return duplicate rows?
Write a sql query to convert all character to uppercase after hypen.
Write a query to display the current date in sql?
Can we delete column in sql?
What is pl sql block structure?
What is on delete restrict?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is record in pl sql?
What is the use of triggers?
Why coalesce is used in sql?
Can you have a foreign key without a primary key?
Define join and name different types of joins?
Why triggers are used?
How do I run a sql trace?
