Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deterministic functions not recognized by optimizer - will they ever?
Hi,
DB2 UDB remembers the last input to a determinstic function. If it didn't change
it will skip the call and recycle the last output.
For constant expressions based on parameter markers DB2 also has the concept of
a "once only".
Finally there is such a thing as constant folding which evaluates various
builtin functions at compiletime
(such as: (5 + 6)).
Cheers
Serge
-- Serge Rielau DB2 UDB SQL Compiler Development IBM Software Lab, CanadaReceived on Tue Apr 16 2002 - 10:51:44 CDT