Override Default Optimizer Behaviour for SQL in PL/SQL blocks

(Garry Robinson) Oracle’s default behaviour dictates that SQL statements embedded in a PL/SQL block are always executed with the ALL_ROWS optimization method. For OLTP applications that rely on packaged stored procedures, this can be bad news for response times. OLTP queries need to return results b

Read More - Register for Free Membership