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
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.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Mention few advantages of router transformation over filter transformation.
What is main use of mapplet?
How do you take back up of repository?
Global and Local shortcuts. Advantages.
What are the tasks that source qualifier perform?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a filter transformation?
What is the difference between informatica 7.0 and 8.0?
what is the complex transformation you used in informatica
what is the hint? how to use it to reduce the query processing in program?
What is the sequence generator transformation in informatica?
What is the need of etl tools?
Quickly characterize reusable change?