Improving SQL efficiency using CASE - Doug …

← Back to document page

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. The Oracle server engine is designed to handle large data sets efficiently but sometimes developers try to break them up into smaller discrete pieces of work (the row-by-row approach).

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.

  Using, Power, Efficiency, Improving, Case, Decode, Doug, Improving sql efficiency using case, The power of decode