|
What is a deterministic function? What are the advantages if we define a function as a determnisitic? Thanks in advance Regards BI DWH BALA
(comments are locked)
|
|
A deterministic function gives always the same result to given parameters. The result of a deterministic function depends only from the input. It can have more than one parameter. Samples of deterministic functions: length, to_upper, trunc, substr Oracle uses deterministic functions building function based indexes. Be deterministic is necessary because oracle stores the function result into a normal index. At query time the optimizer calls the function again for query parameters but not for all table values. HI.. Can we define a procedure also deterministic?
Nov 27 '09 at 02:22 PM
BI DWH BALA
No. Only plsql functions can be defined to be deterministic. Procedures cannot be used in places where functions should be deterministic.
Nov 30 '09 at 06:22 AM
Christian13467
(comments are locked)
|
