Thanks to all who have responded.

This indeed helped me and hope that this discussion ahead will help a lot like me.

--Gaurav

Thanks Mr. Vyas

I have gone through the site.

Your prompt response saved a lot of time.

Thanks Again,

Gaurav Kothari

Hi Jeff/Jason,

First of all thank to you guys, for propmptly replying to the Query.

I checked out the Execution plan on your suggestion (i generally dont do it, but from now...

Jeff,

i have clustered index on the tables primary key column.

and among all this three columns there is no primary key column.

--Gaurav

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...