AFAIK, they are semantically equivalent and should be rewritten in the same way. Cf. page 10 from this excellent whitepaper by Ani: Query Processing Based on SQL Anywhere 12.0.1 Architecture, as referenced in this doc page. I thought so too (equivalent) anyway in real world I see totally different plans which are used... Thanks for the link, I wasn't aware of this paper!
(30 Oct '12, 07:28)
Martin
Replies hidden
Well, I'd just noticed it today and really like to share that link:)
(30 Oct '12, 07:47)
Volker Barth
|