Thank you very much Ann, it's very clear now. Greetings.
Walter. On Sun, Sep 27, 2015 at 5:23 PM, Ann Harrison [email protected] [firebird-support] <[email protected]> wrote: > > > > > On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' > [email protected] [firebird-support] < > [email protected]> wrote: > >> >> >> The only way to know how many contexts a stored procedure has is looking >> at the source code and counting handly them? >> >> > The limit on contexts is per statement, not for an entire stored > procedure, trigger, or whatever. A statement is a SELECT, INSERT, DELETE, > or UPDATE. > > Each table reference is a context. So, for example, a reflexive join has > more than one context for the same table. An update with lots of > subselects has contexts for each part of the subselect. A statement that > references a view has contexts for every table reference in the view. > > So, don't worry about the total number of contexts in a stored procedure, > but do worry about the use of complex views in apparently simple > statements. > > Good luck, > > Ann > > > > >> >>> >>> >> >> >> ------------------------------ >> > > >
