Subject | Re: rdb$procedure_parameters non index read |
---|---|
Author | Dmitry Yemanov |
Post date | 2012-01-10T05:43:59Z |
09.01.2012 20:53, ma_golyo wrote:
Dmitry
>Does it cause you any real issues?
> I'm analysing my stored procedure run with IBExpert, and I can't figure
> out what can cause rdb$procedure_parameters non index reads.
>
> facts :
> - procedure do not read rdb$procedure_parameters directly
> - procedure creates and alters procedures, view, triggers (via execute
> statement in autonomous transaction)
>
> It looks like, that firebird inner engine does something wrong, and do
> not user index (missing index or wrong select?).
Dmitry