I have learned as much :-). I dont have index on currency.

Seems like I have to drop the view and add ACCOUNTNAME field directly
into STAT_HISTORY table.


Riho Ellermaa

>
> The first one has to eliminate duplicates - that involves
> many more hits per row because it first has to find all of
> the duplicates. Also, if you have an index on currency and
> it only has a few possible values, you should drop the index
> and possibly recreate it as a composite of currency + the PK.
>
> Particularly if most of the rows have the same currency
> value, you'll probably find a horribly long dup chain for
> that index when you run gstat. Long dup chain = death to performance.
>
>