Does SA10,11,12 support VIEW PUSHED PREDICATE optimization technique like ORACLE has? Thanks! |
Predicate pushdown has been part of SQL Anywhere since Version 8... perhaps earlier, but the earlier docs don't talk about it. ( This is the Early Bird answer, Glenn Paulley And The Engineers can provide more detail :) One of the very advantages of SQL Anywhere seems to be that I have never been confronted with this optimization while my views do have used it silently - "Stealth optimization":)
(15 Jul '11, 07:52)
Volker Barth
|