Dear Hanshi

Thanks for your reply. But if you see my query it has got differnt where clasues for the 2 query hence can not use roll up.

There is no performace issue as idexex are defined.

I only wnated to see if the same query could be written in any other better way.