Sign Up Login


  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

How many types of triggers are there in pl sql?

0 Answers  

What are the types of records?

0 Answers  

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

What is sql entity?

0 Answers  




What are different sql data types?

0 Answers  

how can we repair a mysql table? : Sql dba

0 Answers  

How do I find duplicates in two columns?

0 Answers  

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

What is the difference between join and natural join?

0 Answers  

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories