>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
It doesn't show the XML for me, for some reason. I'll try to look at them tomorrow, as it's rather late here now.
If it's not broken, fix it until it is.
My Blog