| |
GeekInterview.com > Interview Questions > Oracle > PL/SQL
| Print | |
Question: DeCode Performance
Answer: Performance wise which is a better option if-else construct or a decode? Why |
| April 04, 2009 03:56:35 |
#2 |
| parag_tyagi2001 |
Member Since: December 2007 Total Comments: 1 |
RE: DeCode Performance |
decode is much faster then If -Else because decode in built already have all the values of the column which we want to decode whereas in if - else statement , we need to explicitly specify.
please anyone correct me |
| |
Back To Question | |