8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for LATERAL Inline Views, CROSS APPLY and OUTER APPLY Joins in Oracle Database 12c Release 1 (12.1)


LATERAL eval said...

Hi Tim, according to my experiments, LATERAL always ended up with NESTED LOOPS. So IMO LATERAL ensures the inline view is evaluated later as a lookup table, i.e. never becomes the driving one. This way, it could allow for the inline view to reference columns from outside, because the outer part would be already evaluated. Therefore I don't see LATERAL just as alternative syntax. Regards and thanks

Tim... said...

Hi.

I explicitly say, "In the case of these simple examples, this is just a basic query transformation, allowing us to use an alternate syntax. Of course, that's not to say there isn't something more interesting under the hood for other cases."

Then show a more complicated example that shows lateral is not always transformed. :)

Cheers

Tim...

LATERAL transform said...

Tim, my post was not meant in the way I don't agree with you. Right the opposite, I agree that LATERAL causes some transformation to kick in and just proposed my way of understanding it, what the transformation actually could do. Hope this clears up my previous post. Actually I love your site, I always learn something new to try or at least to think of. Cheers, Daniel

Tim... said...

Hi.

Don't worry. I didn't take offence. Just pointing out I had made the point. :)

Thanks for the support. Happy to receive feedback. Hope I didn't scare you off. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!