Results 1 to 5 of 5

Thread: Is Decode() the most efficient?

  1. 12-15-2008, 09:09 AM #1
    kelbel
    kelbel is offline Registered User
    Join Date
    Oct 2006
    Location
    Denver
    Posts
    4

    Is Decode() the most efficient?

    I have very large Decode statements in my sql. Is there anything that is more efficient?

    Thanks!
    Reply With Quote Reply With Quote
  2. 12-15-2008, 10:55 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try CASE statement, it is easier to understand and read as well.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 04-06-2009, 04:47 AM #3
    srikanth.mss
    srikanth.mss is offline Registered User
    Join Date
    Apr 2009
    Posts
    20
    Can anyone tell me the difference between DECODE and CASE. Which is better. i suggest CASE. is it right?
    Reply With Quote Reply With Quote
  4. 04-06-2009, 07:15 AM #4
    delirium
    delirium is offline Registered User
    Join Date
    Apr 2009
    Location
    European Union
    Posts
    6
    Quote Originally Posted by srikanth.mss View Post
    Can anyone tell me the difference between DECODE and CASE. Which is better. i suggest CASE. is it right?
    There are no differences between DECODE and CASE. Remember for future that you can not use DECODE() in PL/SQL, but CASE.
    Reply With Quote Reply With Quote
  6. 04-07-2009, 05:04 AM #5
    srikanth.mss
    srikanth.mss is offline Registered User
    Join Date
    Apr 2009
    Posts
    20
    regarding performance oriented, is there any difference.

    I think CASe has the ability to check the ranges.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules