Subject Re: [firebird-support] Re: memory use
Author Alexandre Benson Smith
manoel_sa wrote:

>(ok thx, but)
> - i'm using FB2
> - what tools/cmds are available in order to check this ('ps' cannot
>say anything of FBs inner behavior)
What do you want to know ?

If you are refereing to the slow queries.

We need at least the following information to start trying to help:
The query
the execution plan
Involved tables metadata
Something about index selectivity (index statistics)
the execution time
and perhaps some more info that I forgot to mention.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil