Subject Re: [firebird-support] Re: INDEX on Numeric Column
Author Ann W. Harrison
robertz82 wrote:
>> Not at all, AFAIK... Did you updated the Index Statistics?
>> regards,
> I just did and performance feels a bit better now, but it's still far from running fast. I also tried ascending/descending indexes without a difference. Unfortunately I'm really out of ideas now. Only thing that comes to my mind is that theres any problem because it runs inside a stored procedure.

You'll need to reload the stored procedure which can be done
by deleting and recreating it or by closing all connections to
the database (superserver) or by closing the current connection
(classic or embedded).

Good luck,