Subject Re: how to retrieve the indexed reads and non indexed reads statistics
Author svanderclock
yes i see it, but no exemple :(
in MON$RECORD_STATS i only have STAT_ID and don't know how to connect the the SQL i just do...

thanks by advance
stephane

--- In firebird-support@yahoogroups.com, "emb_blaster" <EMB_Blaster@...> wrote:
>
>
> --- In firebird-support@yahoogroups.com, "svanderclock" <svanderclock@> wrote:
> >
> > Thanks ann,
> >
> > but do you know how to use the MON$ table? any doc somewhere or sample to retrieve the indexed reads vs the non indexed reads ?
> >
>
> take a look in Firebird 2.1.X Release Notes, in pages 111 and 112. I think that the tables are MON$IO_STATS (I/O statistics) and MON$RECORD_STATS.
>
> WTH,
>