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 batches?

814


is it possible to index the data in cache of lkp transformation ?

1733


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8028


What are the features of complex mapping?

870


Explain the use of aggregator cache file?

932


Explain the different kinds of facts.

747


What are ETL Tools?

852


Explain scd type 3 through mapping.

769


Difference between Data and Index Caches?

872


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2069


explain abt ur project architecture?

1929


Mention few power centre client applications with their basic purpose?

731


What is a node in Informatica?

820


What is status code in informatica?

789


Explain how to import oracle sequence into informatica?

775