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
- 6874 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 |
Explain some predefined exceptions.
What is the use of pl/sql table?
What are the benefits of stored procedures?
Can a primary key be a foreign key?
What does rownum mean in sql?
How subquery works in sql?
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
Explain the difference between 'between' & 'and' operators in sql
What is a temp table?
What is record data type?
List the various privileges that a user can grant to another user?
How do you pronounce sql?
-
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)
