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
Implementation methodology
Explain the code page compatibility?
what is Active lock explain
Define update strategy?
How to handle decimal places while importing a flatfile into informatica?
How can a transformation be made reusable?
What is the different lookup cache(s)?
Which files are created during the session rums by informatics server?
Define the various join types of joiner transformation?
What is the sequence generator transformation in informatica?
have u done any performance tuning? how u ll do?
What are the advantages of informatica?
What is standalone command task?
What is joiner transformation in informatica?
How to open an older version of an object in the workspace?