001tuning
Oracle 12c: PRAGMA UDF – the truth
Let’s check, why PRAGMA UDF makes execution faster, then regular function. C function responsible for calling a PL/SQL code from SQL is called "plsql_run":
5 MIN READRead the field notes ↗
FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
1 field notes / page 1 of 1
Let’s check, why PRAGMA UDF makes execution faster, then regular function. C function responsible for calling a PL/SQL code from SQL is called "plsql_run":