Could somebody comment on a better way of doing this. I have three tables...all three close to 2 Gigabytes each. and all three have the same structure. It is taking alot of time to finish the query. Infact still not done at two hours. I am selecting data from these three tables and doing a union of the results so my queries look like this.