Sasa Mihajlovic wrote:

> Hi,
>
> I have firebird database around 2GB with some tables over milion
> records and my db is very slow, I try with indexing, recomputing
> indexes and perfomance are stil slow.
> ...

It could be a case of the optimiser trying to be too smart...
If so, it can usually be remedied easily.

Show us (at least) the query and the plan. Tables, indexes,
counts/selectivity can be helpful as well.


--
Aage J.