Jan Bakuwel wrote:

>
> Oops... overlooked that obvious one (guess its getting late).
> While we're at it... any ideas why Firebird isn't using more of the
> available RAM (I was hoping it would not need to use temp files... the
> indexes should fit in RAM...).
>

The configuration file was set up when memories were much smaller - I
don't remember how the maximum size of a sort segment is set. Do
remember that during the sorting for creating an index, there will
be times when the intermediate result will be larger than the final
index -- at least I think it is during a merge.


Regards,


Ann