Tryed with the latest FB2.5 snapshot. It works! (It has 2 new index in rdb$procedure_parameters)

Now I has only 92 index read. :)
(Execute time = 7s 422ms)

Thank you!

--- In firebird-support@yahoogroups.com, "ma_golyo" <ma_golyo@...> wrote:
>
> Tryed with ACS and DESC index. No change, still the same non index reads.
>
> Do I upload my test database?
>
>
> --- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@> wrote:
> >
> > 10.01.2012 13:36, ma_golyo wrote:
> >
> > > The question is, the non index read is a firebird engine bug or not?
> >
> > Maybe not really a bug but something sub-optimal.
> >
> > > (I think standard DDL command shoud ALWAYS read via indicies in the
> > > background.)
> >
> > Try creating an index on RDB$PROCEDURE_PARAMETERS.RDB$FIELD_SOURCE and
> > see whether it helps. If it does then it's a known issue that has
> > already been fixed in the latest v2.5.2 snapshot builds.
> >
> >
> > Dmitry
> >
>