Monthly Archives: February 2016

NVL Function Internal Behaviour in Oracle for Scalar Calls.

During a performance analysis, identified a NVL Scalar Function calls was eating up lot of SQL time. Scalar function was like below, NVL ( A_Table_Column, (SELECT COUNT(*) FROM TABLE_B WHERE <>) ) If we check Scalar Columns, we are ideally … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment