GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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