Query Rewrite

General
Enthusiast

Query Rewrite

The context I am asking is about a scalar query with  inner joining and outer joining .

In Query Rewrite, when it pushes projection into views, I understand like in Relational Algebra, if 

I have R{A1,B1} containing  3 tuples say {a1,b1},{a2,b1},{a3,b2} , the projection of R on {B} will be 

{b1},{b2}.

Does it mean that when I get the result from this processing along with condition if any , it will be joined with folded view(s) if any and do further rewrite if possible.....?

Please educate me here.

Thanks and regards,

Raja