<br />Hi,<br /><br />can anyone let me know that why Nested Loop path is not allowed if jointype<br />are JOIN_RIGHT or
JOIN_FULL?<br/><br /><br />At match_unsorted_outer(), we having case where nestjoinOK = false if there are<br
/>JOIN_RIGHTor JOIN_FULL. <br /><br />match_unsorted_outer()<br />{<br />....<br /> case JOIN_RIGHT:<br />
case JOIN_FULL:<br /> nestjoinOK = false;<br /><br />..<br />}<br /><br />wondering why ?<br /><br
/>Regards,<br/>Rushabh Lathia <br /><br /><a href="mailto:rushabh.lathia@EnterpriseDB.com">
rushabh.lathia@EnterpriseDB.com</a><br/>