LAKSHMAN CHOWDARY Oct 17th, 2005 USING COMMENT LINES WITH (+) SIGN YOU CAN PASS THE HINTS TO SQL ENGINE----------->/* +PARALLEL() */ dhampack Profile Answers by dhampack Nov 24th, 2008 I would say, write more sql statementfor exin join statement if x=y, y=z (you can also add x=z to give more hint to optimizer) Give your answer: If you think the above answer is not correct, Please select a reason and add your answer below. - Reason - Answer is wrong Spelling Mistakes Duplicate Answer Inappropriate Answer Other Related Answered Questions Balance payment journal entry Identify header, detail and trailer records Syntax for year checking and processing date Compressible testing of concrete Purchase of vehicle on emi Sequence job creation scenario Depriciation Name change dynamically Service tax Test case test step fails Related Open Questions Basic program for banking in c++. How can we fine tune the command object when we are expecting a single row or a single value ? Program Quality center graphs in v 11.0 Why do we pass actionmapping object in validate(...,..) method in struts? Soap client Does a problem make you a better person? Noise power output Acid test Motion planning Latest News It looks like you are using an AD Blocker! Please Turn OFF your ad blocker - OR - LOGIN to continue using GeekInterview website. Disable Ad Blocker Learn More Login GeekInterview Login Create your GeekInterview account Signup Continue Reading after Disabling Refresh
dhampack Profile Answers by dhampack Nov 24th, 2008 I would say, write more sql statementfor exin join statement if x=y, y=z (you can also add x=z to give more hint to optimizer)
How would you pass hints to the SQL processor?