At 03:24 PM 10/10/2005 +0530, you wrote:

>Hi,
>
>Actually I meant that the COUNT on any table takes a huge amount of
>time. It is further compounded by the GROUP BY clause.
>
>For the following query it takes 8 seconds to execute
>select USER_KEY, COUNT(1) from FUND_SELECTION
>GROUP BY USER_KEY
>
>The total count in the table is 49,175 records only.


>When the table size grows to millions, performance deteriorates further.
>Please help.

You're quite right, it does. You cannot squeeze blood from a stone. Why
do you want to count all of the rows in the table? Describe the problem
you want to solve and we'll help with that.

./heLen