indexes – Learning is not a spectator sport

New podcast episode! How do indexes work?

It’s a return to the focus of “Back to basics” in my latest episode. Pick up a reference book and

Glance through any text book, blog post, video tutorial etc on the topic of database indexes and you’ll typically chance

Every database has indexes…but should they? In this episode, lets consider a different proposition. What if the indexes you have

I’m a big fan of giving developers the tools they need to tune their applications in Production if that is

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

This question got posed on Twitter today I answered briefly on Twitter, but I thought I should give it some

Man, it gets my goat when people start pontificating nonsense on Twitter. Yeah, I know, I know, I shouldn’t get

We had a question on AskTOM inquiring about how to handle the issue of only 8 storage indexes being possible

In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a