Indexed View w Business Logic

by Andy   Last Updated July 12, 2019 05:26 AM

I have been tasked to create several 'views' on data that exists on our analytics server. These views are 'business logic' heavy, but will be referenced by potentially multiple tools, so we are trying to centralize the logic into the sql server.

In essence, we have two operating companies, so we select a bunch of stuff from a bunch of tables into a 'standard' format, including a few columns that use formulas/case statements to output something meaningful to the biz.

Each company has a view. Then there is a parent view that combines them with a union all. The two company specific views are maintained by different people, but the both sides have the same columns / definitions / etc.

I was hoping to create an indexed view on the unioned view to materialize it as we are having some performance issues in our end point analysis tool.

Any help is appreciated! Thanks in advance!



Related Questions


Updated April 11, 2017 12:26 PM

Updated March 15, 2019 05:26 AM

Updated February 16, 2019 21:26 PM

Updated July 04, 2019 20:26 PM

Updated December 13, 2018 03:26 AM