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)
Having an indexed view is almost same as having a table. As you have troubles creating it, why don't you think for another alternative?
- You can investigate on improving the performance of the queries using those selects you want to put in a view.
- You can create a separate table and add some work around to fill it appropriately.
SQL Server developer at Seavus