Thanks to all.

I rewrote the query and I got the results in less than 2 sec.

I am not sure if @ or # will delay the fetch but the joins...

The Query and the actual plans with 2 columns included and with out 2 columns are attached

only two float columns that has very small values are causing the delay. other float columns when selected are not a problem.

AWESOME.

Thanks for the info and it solved my problem.

Thank you .

Sree

I have a table with 82 million records.

I want to test if there are any duplicates and I ran a query

SELECT DISTINCT

...