Ann,

> > All of those mycolX columns are NUMERIC(10,3). Since table data is
> increasing steadily (~100.000 rows by now), performance is getting
> critical. So I tried to speed up things by creating a simple INDEX on
> these columns, but unfortunately this made no significant difference. I
> guess it has something to do with floating point values since indexes
> on integer type fields generally work well. Whats the best way to speed
> it up?
>
> First, numeric(10,3) is stored as an integer. If the value stored
> 111.999, the stored representation is that times 10**3 or 111999.

Isn't there a difference in storage between Dialect 1 and 3?


Sean