All Forums General
Raja_KT 1246 posts Joined 07/09
18 Oct 2013
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

Raja K Thaw

My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1

Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.