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
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