constraints – Learning is not a spectator sport

Take care with automatic indexes

This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by

In an Office Hours session a couple of months back, I covered an important change that comes to regular expressions

The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the

Java and Oracle expert Lukas Eder tweeted yesterday about a potential optimization that could be done when reviewing database SQL

When it comes to giving the cost based optimiser the best possible chance to make the “right” decisions, many DBA’s

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

Here’s a very simple example of a table called PARENT being a (surprise surprise) parent in a referential integrity relationship