on 2011 Jul 15 5:08 AM
Does SA10,11,12 support VIEW PUSHED PREDICATE optimization technique like ORACLE has? Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.