SQL Anti-Pattern: Indexing Every Column Individually

Indexes are magic, right? Add one and magically the performance of a query improves.

Well, not really. Each index has a cost, and thoughtful multi-column indexes will go a lot further than individual indexes. Let’s dig into the details.

What an Optimizer Does

Relational databases require queries to specify what data they want returned with no specification of where that data is on disk.… Read the rest

Continue reading »

Cross-RDBMS Content?

The database conference organization I’ve focused on for most of my career – IDUG (International Db2 Users Group) is not interested in cross-platform content. Despite being a top speaker most conferences, they are not interested in content from me that covers things like transitioning from Db2 to MySQL or technical writing about database concepts.… Read the rest

Continue reading »