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
What is different between the data warehouse and data mart?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is meant by query override?
Which development components of informatica have the highest usage?
Performance tuning( what you did in performance tuning)
What is fact table? Explain the different kinds of facts.
What is pmcmd command?
How do we call shell scripts from informatica?
how to load rows into fact table in data warehouse
What do you understand by term role-playing dimension?
What is main use of mapplet?
What is depict expression change?
What do mean by local and global repository?
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.
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?