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

Implementation methodology

1266


Explain the code page compatibility?

645


what is Active lock explain

2374


Define update strategy?

641


How to handle decimal places while importing a flatfile into informatica?

727






How can a transformation be made reusable?

667


What is the different lookup cache(s)?

617


Which files are created during the session rums by informatics server?

709


Define the various join types of joiner transformation?

561


What is the sequence generator transformation in informatica?

617


have u done any performance tuning? how u ll do?

1862


What are the advantages of informatica?

576


What is standalone command task?

715


What is joiner transformation in informatica?

629


How to open an older version of an object in the workspace?

621