Optimizer and ANSI Joins
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 29 Jan 2019 09:08:56 -0800
Message-ID: <CAORjz=Pq7TO+DM40pYn8Z0secb4CBDtfsCSCmWgMC=L72TpyLg_at_mail.gmail.com>
Hello All:
Date: Tue, 29 Jan 2019 09:08:56 -0800
Message-ID: <CAORjz=Pq7TO+DM40pYn8Z0secb4CBDtfsCSCmWgMC=L72TpyLg_at_mail.gmail.com>
Hello All:
Something I have heard a few times is that the Oracle Optimizer does not understand ANSI joins, and that ANSI joins are first converted to some legacy format before the optimizer processes them.
Does anyone here know if there is any truth in this?
Some things that come to mind:
- perhaps it was true at one time (9i)
- only partially true
- a blatant lie started by a SQL Server Fan.
OK, that last one was uncalled for, but a little humor is necessary sometimes :)
I have googled around for this a bit, but find nothing that really discusses the topic.
Thanks,
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 29 2019 - 18:08:56 CET