Hi

There is not a lot of records for Firebird.

Try to define indices on column USER_KEY.

What is type of column USER_KEY?

Best Regards
Miki A

> Hi,



> 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'



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



> 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.



> Please help.



> 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@...
> <mailto:hemant.sapre@...>