-
Learning SQL at an early age
Pete Finnegan blogged about becoming a dad a few days back and Gary Myers followed up with his version of an SQL Primer for a toddler. This got me thinking of how the child subjected to this may react . As having SQL read out loud even with pictures from the result set may not…
-
The WITH clause
To mix the last post with something that may be easier to digest, I’ll make this one about one of my favorite keywords in SQL. It is the WITH clause. I can only think of one bad thing with it; it’s name. It’s virtually impossible to search for information on something with a name that…
-
Commit frequency and Undo
Too frequent commits can lead to performance problems, but can it also affect how much undo the updates generate? The fact that very frequent committing causes performance problems has been noticed by almost every Oracle developer with even just a couple of months experience with the Oracle database. However, if commit can increase I/O requests…