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
- 6895 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 different type of normalization? : Sql dba
Why truncate is faster than delete?
How do you write a subquery?
What packages(if any) has oracle provided for use by developers?
Describe different types of general function used in sql?
what is acid property in database? : Sql dba
Why functions are used in sql?
Why is a primary key important?
How do you drop a trigger?
What is difference between rank () row_number () and dense_rank () in sql?
What is the difference between python and sql?
What is rollback?
-
Oracle (3259) - 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)
