devxlogo

April 21, 2007

Predicate Pushing

Oracle supports the pushing of predicates into a given view. Suppose you have a set of layered views: –View OneCREATE VIEW vw_layer_oneAS SELECT * FROM emp;– View TwoCREATE VIEW vw_layer_two_dept_100AS