Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What are the built in functions of sql?

0 Answers  

Explain what is rdbms?

0 Answers  

How to execute a stored procedure?

0 Answers  

what is the difference between char_length and length? : Sql dba

0 Answers  

how to rename an existing table in mysql? : Sql dba

0 Answers  

How to convert ms-excel file to oracle table?

2 Answers  

What is sqlerrd?

0 Answers  

Give the structure of the function ?

2 Answers  

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

Does oracle roll back the transaction on an error?

0 Answers  

How are functions and procedures called in PL/SQL?

0 Answers  

What are the types of join in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories