Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

If statement is faster or Case statement faster?

127021Apr 17 2006 — edited Apr 5 2012
Hi All,

I'm facing performance problem, i''m having 2000 lines of codes having a lot of IF-ELSIF-ELSE statements. If i use Case statement it will be faster ? does it make any diffrence? Pls clear my doubt.

Thanks ,
Ramana.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2012
Added on Apr 17 2006
7 comments
3,955 views