Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: design
Please keep your foreign keys
I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key relationships between tables. The blog post discussed the issue of foreign keys being temporarily disabled to perform data loading, and then encountering the problem…
It’s just bad code or bad design … most of the time
Some years ago I wrote an article for the UKOUG magazine called “Want a faster database – Take a drive on the M25”. For those not familiar with the United Kingdom, the M25 is one of its busiest roads (M = “motorway”) and because…
