I suppose the odd thing is that when we were executing our DDL we found
that our triggers and stored procedures where not taking advantage of
indices if autocomit was off and if we executed the indices creation and
procedure creation in the same transaction. We took this to mean that
the indices had to be created and committed first because maybe the
procedures had embedded plans at creation time (or something like that).
When we turned autocommit on for the DDL commands, the stored procedures
and triggers performed dramatically better. Seemed odd to be, but I'm
sure a number of misconceptions lead us to this conclusion. Any
thoughts?