How to index only rows of interest
This is a classical example of what you can achieve by combining several existing features and implemented in a new way, not described within Oracle docs. Here I’m using the fact that Oracle won’t add entry into the index structure if indexed column value is null, in combination with the function-based indexes functionality. I’ve created […]
PL/SQL vs Java vs C vs Python for CPU intensive tasks – architectural decision
Main goal of this article is to show performance comparison mainly between PL/SQL and Java (running inside and outside of the Oracle Db), with included C and Python code just to be able to compare results. This may hopefully help you to decide where you are going to put Java CPU intensive code when you’ll […]
Case versus good old Join
SQL language gain a lot with introduction of the “Case” statement. Many SQL programmers are using it, as it is more logical way to accomplish some task without even thinking that SQL language is much older then Case statement, and there is always another (more efficient) way to get the same result. In this post […]