Hi All,

Funny It may seem cos I am asking this without any referance...

Whenever you look at a querry and see a lots of UNION ALL in them..
What is the other option that that should come into your mind immediately...Cos I believe UNION ALL takes lots of time to execute..

Thanks in advance,