oracle - DETERMINISTIC 和 PARALLEL_ENABLED 与 Oracle 中函数的区别

Question

Oracle 函数中的deterministic 和parallel enable 子句 在数据访问限制方面有什么区别？

Answer 1

如 documentation on the CREATE FUNCTION statement 中所述:

DETERMINISTIC

Indicates that the function returns the same result value whenever it is called with the same values for its parameters.

...

Do not specify this clause to define a function that uses package variables or that accesses the database in any way that might affect the return result of the function. The results of doing so are not captured if the database chooses not to reexecute the function.

和

parallel_enable_clause

Indicates that the function can run from a parallel execution server of a parallel query operation. The function must not use session state, such as package variables, as those variables are not necessarily shared among the parallel execution servers.

...

• The optional streaming_clause lets you order or cluster the parallel processing by a specified column list.

  • ORDER BY indicates that the rows on a parallel execution server must be locally ordered.

  • CLUSTER BY indicates that the rows on a parallel execution server must have the same key values as specified by the column_list.

这是两个完全不同的选项，如果您需要，应该使用它们。区别是绝对的，无论可能存在什么限制，因为它们不是一回事。