>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