Especially you want to create Indexed View (Materialized View) with UNION inside that view which is not possible: Cannot create index on view 'sql.dbo.vw_INDX' because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view.

But I need that view in another Query to join with.

PS: MS SQL Server 2014 Enterprise