performance – Page 8 – Learning is not a spectator sport

Problematic SQL ? PL/SQL is your friend.

So then… I’ve written a crappy piece of SQL. It wouldn’t be the first time I’ve done it… and it

Often, to do an existence check for data, people issue a “SELECT COUNT(…)” against the relevant table. So in pseudo-code,

I’ve lost track of the number of times I’ve worked with systems that didn’t run brilliantly because every database operation

In the previous post, I mentioned that for a programming environment fetching rows from the database, then the method of

In various programming environments, a common metaphor is to open a cursor on the database (a REF CURSOR in Oracle

Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure

Every …. single …. time…. Why does index monitoring make me scratch my head and charge off to google so

My friend Kyle wrote a blog piece a while back http://www.kylehailey.com/what-delphix-does-in-1-minute-22-seconds/ Now, not to criticise Delphix (in fact,the opposite –

The world is obsessed with I/O nowadays…. This is understandable – we’re in the middle of a pioneering period for

I found this in a trace file recently INSERT INTO T (X) VALUES(:B1) call count cpu elapsed disk query current