July 30, 2010, Friday, 210


DETERMINISTIC

From SQL PL Guide for DB2

Jump to: navigation, search

DETERMINISTIC and NOT DETERMINISTIC option

Specifying a procedure as DETERMINISTIC procedure in the create statement means that for each invocation with the same values of the input parameters you will get always the same results. With this option DB2 has more possibilities for optimization which can improve the performance of the stored procedure.

The other option is NOT DETERMINISTIC. This is the default for this option.

Retrieved from "http://sqlpl-guide.com/DETERMINISTIC"