>Hi
>
>Attachment
>
>without Union it take 1sec with union it take > 3min
>From Execution Plan it highlight missing index
>But after I add in the recommend index it take 4.51min

post images of two execution plan.

time for this is ?

SELECT myView.*
, (SELECT TOP 1 TableZ.FieldA FROM  DB2.dbo.TableZ WHERE myView.Key = TableZ.Key)
FROM MyView