Re: DBD::Oracle dbd_st_execute slow speed

[Mike Towery]

Confirm that there are supporting indexes on the table columns that the 
FKs reference.  If not, that can definitely slow down your inserts as 
the tables grow larger.

There should be indexes on:
MJMC.ABI_FL_SYS_FMT (ABI_FMT_ID)
MJMC.NDE_DATA_HIST (DATA_COLL_ID)

Regards,
Mike Towery