rules repository

G-7460 – Try to define your packaged/standalone function deterministic if appropriate.

A deterministic function (always return same result for identical parameters) which is defined to be deterministic will be executed once per different parameter within a SQL statement whereas if the function is not defined to be deterministic it is executed once per result row.

Tags: Stored Object, Performance.

Quality area: Reliability. Severity: Major. Fixing time: Local-medium.

No rule selected