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 will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

What is set serveroutput on?

0 Answers  

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

What are the operators used in select statements?

0 Answers  

How to move files from one directory to another in pl sql?

0 Answers  

How do I find duplicates in a single column in sql?

0 Answers  

What is pl sql collection?

0 Answers  

Can we use insert statement in function?

0 Answers  

How do you update sql?

0 Answers  

What are the packages in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories