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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1995


What is the Process to creating lookup transformation in informatica

991


Mention few power centre client applications with their basic purpose?

898


What are the different transaction levels available in transaction control transformation?

1132


Why update strategy and union transformations are active?

995


Explain the features of connected and unconnected lookup.

889


What is Session and Batches?

1048


How to configure mapping in informatica?

1127


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

994


What is the difference between STOP and ABORT options in Workflow Monitor?

1196


What is different between the data warehouse and data mart?

1010


Explain the different dimensions.

920


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2087


Briefly describe lookup transformation?

994


How might you approve all mappings in the archive all the while?

968