Vlad Khorsun wrote:

>
> EXECUTE BLOCK may be prepared once and re-executed many times
> as well as all other statements.
>

That's true, but the example was

EXECUTE BLOCK
insert statement 1
insert statement 2
insert statement 3
insert statement 4
insert statement ... n
END BLOCK


Each insert statement is parsed, compiled, and optimized separately.


Regards,


Ann