performance – Learning is not a spectator sport

SQL engine and PL/SQL functions

A common pattern I see in database code is the use of a PL/SQL package to hold constants to be

I had an inquiry about the performance of DBMS_PARALLEL_EXECUTE today from a customer. Whilst the utility (as the name suggests)

At my physical design talk at this year’s Yatra tour in India, one of the demos I do is multiple

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

So I started all of this by talking about how PLSQL is going to give you a performance boost, just

So after my post yesterday about PL/SQL being a no-brainer to get an easy boost to application performance, there was

I rarely blog about PLSQL for a very simple reason. It quickly becomes like Halloween night because all the ghouls

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve