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...


what is the hint?
how to use it to reduce the query processing in program?

Answers were Sorted based on User's Feedback



what is the hint? how to use it to reduce the query processing in program?..

Answer / sujatha

Hi,

Hints are used to improve the query performance. Please go
through the below link ...u will get all the info
required...
http://www.adp-gmbh.ch/ora/sql/hints/index.html

Is This Answer Correct ?    0 Yes 0 No

what is the hint? how to use it to reduce the query processing in program?..

Answer / usha

Hints is nothing but clues.
By using hints we can improve the query performence.

Is This Answer Correct ?    2 Yes 2 No

what is the hint? how to use it to reduce the query processing in program?..

Answer / gazulas

by using hints we can direct the optimizer to follow what was specified in the hints. ex: we can direct the optimizer to do a index unique scan instead of full table scan....

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,


how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,


If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  


how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


tell me the push down optimization

2 Answers   Wipro,


Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,


What does command task mean?

0 Answers  


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  


What are the prerequisite tasks to achieve the session partition?

0 Answers  


whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


Categories