Subject Re: [firebird-support] how to detect not optimized query ?
Author Douglas Tosi
On Fri, Dec 4, 2009 at 10:49 AM, svanderclock <svanderclock@...> wrote:
> how to detect not optimized queries ? actually i simply look the time the query take to execute, but it's not good enalf because it's can take time not because of the query but because for exemple the server is overloaded (too much users).

One way is to look for queries that consume too much disk i/o. Check
mon$statements and mon$io_stat or <ad> </ad>.
You may also analyze the query execution plan to identify possible

Douglas Tosi