>
> I am facing problems with the GROUP BY clause. It takes a lot of

time to

> return with the values.
>
> I am trying the following:
>
> SELECT COUNT(1) FROM VW_INSERT_RIP WHERE USER_KEY = '8888'
>

where is the "group by" ???

>
> This query takes 214 seconds to return the value - 785,000 records

from

> 60,000,000 records.
>

214 secods is perfect result for such ugly-dummy usage.
This fast result refreshed my FB love again.

>
> The view internally joins 3 tables. It has index on the FUND_PRICE

table

> (with 60,000,000 odd records) but not on the other lighter tables.
>

where is the view? your codes will help us more than your
descriptions.
Ok, i can get it from you via telepathy but it makes Helen angry.

>
>
> Please help.
>
>

Help? how?
"hey help me, i wrote some bad SQL codes and it works as unexpected"

I did count your rows in a few seconds. i wrote a new SQL command.
but i forgot to paste it in this mail like u. ;)

Regards.
Ali

>
> Regards,
>
> Hemant.
>
> Project Leader - Investment Banking Group
>
> PrimeSourcing(tm) "Add Value Reduce Risk"
>
> i-flex solutions ltd., Mumbai
>
> Tel Office: +91-22-5642-7144
>
> e-mail: hemant.sapre@i...
> <mailto:hemant.sapre@i...>
>