Home Forums SQL Server 2008 SQL Server 2008 - General Issue while creating indexed view after joining two non related tables RE: Issue while creating indexed view after joining two non related tables

  • July 5, 2013 at 12:57 pm

    #1630164

    shyam00 (7/5/2013)

    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.

    Hi,

    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.

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com