First of all thanks Lutz for the suggestion.

The reason why i used union is that i dont want to have duplicates.

Also, i am having smillar query with 8 intersect operators between different Select statemnts.

i checked the Query plan and found that clustered index scanning is taking 27% time.

A Quick help and good suggestion is appreciated,

Thanks again.

Gaurav Kothari