Home Forums SQL Server 2014 Development - SQL Server 2014 Views based on Multiple tables causing Locks? RE: Views based on Multiple tables causing Locks?

  • February 5, 2018 at 1:52 am

    #1978510

    subramaniam.chandrasekar - Monday, February 5, 2018 1:10 AM

    ash.blair - Friday, February 2, 2018 8:39 AM

    Sorry it is UNION ALL, that was me just being lazy in typing up the question.  Thanks for the help.

     besides if you're facing performance issues while retrieving the data from the tables OR while querying views,you could go for Indexed views.

    UNION/UNION ALL are not permitted in indexed views, and even if it were, since these views are just combining a bunch of tables, an indexed view would likely not be helpful, and would take up a lot of space.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass