Thanks for the reply.

Is there any way to tackle my scenario mentioned here.?

I need to combine (UNION) two non related derived tables and create an indexed view on top of that. Since UNION operation is not allowed under indexed views, I had tried to join then using OUTER JOIN. (I need data from both the non related derived tables unconditionally)

Please advice.