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. In this article I ll focus on Improving application performance by Improving the efficiency of your code. One of the first and most valuable lessons I learnt about Oracle performance is to do as much work in as few steps as possible.

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:

  Using, Efficiency, Improving, Case, Improving sql efficiency using case

Information

Related search queries