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 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"🙂
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.