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

What is different between the data warehouse and data mart?

1111


What is the difference between writing a joiner query in ANSI style and THETA style?

2432


What is meant by query override?

1112


Which development components of informatica have the highest usage?

1095


Performance tuning( what you did in performance tuning)

2052


What is fact table? Explain the different kinds of facts.

1122


What is pmcmd command?

1177


How do we call shell scripts from informatica?

1189


how to load rows into fact table in data warehouse

1227


What do you understand by term role-playing dimension?

1115


What is main use of mapplet?

1176


What is depict expression change?

1190


What do mean by local and global repository?

1276


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2399


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1142