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
- 6947 Views
- Polaris, I also Faced
- E-Mail Answers
Answer / 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 |
What are the possible values that can be stored in a boolean data field?
How do you clear the screen in sql?
Why should I use postgresql?
Is sqlite thread safe?
How do you handle exceptions. Give the syntax for it?
what is the use of set statement in tsql? : Transact sql
Explain the steps needed to create the scheduled job?
Explian rowid, rownum?
What is anonymous block in sql?
What is the use of primary key?
Is coalesce faster than isnull?
What is substitution variable in pl sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
