The following sections contain information about how and when the database server optimizes and executes SQL within an SPL routine.