-
DeCode Performance
Performance wise which is a better option if-else construct or a decode? Why
muraligrandhi
- Jun 7th, 2010
DECODE is faster than IF-THEN-ELSEREASON:Decode is an Oracle built-in function, so no need to pass parameters to this function. Because all the parameters are internally defined but If-then-else statements we should define explicitly, so takes time for execution and converting into P-code.
sanjeevlabh
- Jan 22nd, 2010
The answer to this question would actually depend on the type of applicability of the usage that is being done. i.e. is it required in a query or in a PLSQL block. If it is in a query we cannot use if...
