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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

1102


What is exclusive and normal mode for repository services?

1188


The question was on time stamp. what is the difference between HH and HH24 when to use when.

2120


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1148


can anyone suggest best free Talend data integration training online

1741


Implementation methodology

1759


lookup transformation with screenshots

4045


what is unit testing?tell me proceedure

2270


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2100


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1332


What is rank transform?

1054


What are the features of complex mapping?

1201


Mention few power centre client applications with their basic purpose?

993


Define filter transformation?

1142


What are data-driven sessions?

1255