1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / durgesh kumar behera


1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index ..

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

Post New Answer

More SQL PLSQL Interview Questions

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

Why sql query is slow?

0 Answers  

What are the triggers associated with image items?

0 Answers  

How do you create an update query?

0 Answers  

What is execution plan in sql?

0 Answers  




how can we repair a mysql table? : Sql dba

0 Answers  

What does select top 1 do in sql?

0 Answers  

How does rowid help in running a query faster?

0 Answers  

Which table is left in left join?

0 Answers  

What is autocommit sql?

0 Answers  

Differentiate pl/sql and sql?

0 Answers  

how to extract a unit value from a date and time? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories