You are right, even then it is not faster.

Let me tell you the scenario,

I have to generate a report which is having lakhs of records and need to dispaly it....

Thanks for the reply,

Yes i am taking the sum of flt_amount field based on the transcode in the int_transcode

if the Transcode='TR001' then i need to add float_amount,

it goes upto...