Transcription of Improving SQL efficiency using CASE - oracledoug.com
{{id}} {{{paragraph}}}
Example: marketing
Improving SQL efficiency using CASE - oracledoug.com
Improving SQL efficiency using case Some time ago I wrote The Power of Decode - a paper on using the DECODE function to improve report performance. I was aware at the time that DECODE was being replaced by case but wanted to make sure that the paper applied to as many Oracle versions as possible. case was introduced in Oracle , however, and is a much better option because it is 1) More flexible than DECODE 2) Easier to read 3) ANSI-compatible (if that matters to you) However, case is essentially a better implementation of DECODE so the reasons for using either are similar.
Improving SQL efficiency using CASE Some time ago I wrote ‘The Power of Decode’ - a paper on using the DECODE function to improve report performance.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: