Hi,
I'm having a hard time in understanding the concept of PARALLEL_ENABLE used with functions.
I actually came across on PARALLEL_ENABLE when reading that the RESTRICT_REFERENCES Pragma is deprecated, and instead DETERMINISTINC and PARALLEL_ENABLE shoul be used.
Here are some questions I have:
1. how do DETERMINISTIC and PARALLEL_ENABLE replace RESTRICT_REFERENCES?
With RESTRICT_REFERENCES we were getting compile time errors when violating "purity" rules of functions. Will DETERMINISTIC, PARALLEL_ENABLE noify in the same way, at compile time?
2. I had found some examples of DETERMINISTINC - Hemant's Oracle DBA Blog: DETERMINISTIC Functions , and understood its usage, but I cannot seam to find one for PARALLEL_ENABLE as well.
Could you give me a well explained example?
The definition states:
"PARALLEL_ENABLE indicates that the function can run from a parallel execution server of a parallel query operation" - what does it mean by that?