G-7460: Try to define your packaged/standalone function deterministic if appropriate.
Major
Efficiency
Reason
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.
Example (bad)
1 2 3 4 5 |
|
Example (good)
1 2 3 4 5 6 |
|