Monday, 09 September 2019 19:16

ANSI or Oracle Style Joins?

Written by https://www.thatjeffsmith.com/archive/2019/09/ansi-or-oracle-style-joins/
Rate this item
(0 votes)

I like Oracle, you like ANSI – but that’s OK! We can both win!

How to switch back-and-forth.

A wee secret…even ANSI joins often run as Oracle

If you look at the code,

UNDER the code, the Optimizer has re-written our statement.

SQL Text Expansion shows us the actual SQL Oracle will run for any given statement…see anything familiar?

Yes, that’s a JOIN in the WHERE clause ?
Read 75 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.