>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
Can you post the exact query? Are you using UNION because you can have duplicates?
If it's not broken, fix it until it is.
My Blog