Common Query Plan Patterns: Introduction And Index

Muy Bueno


I’m writing this series because as interesting as single operators can be, you rarely run into interesting query plans that are a single operator. I don’t know exactly how many posts this will end up being. I have a list of about 15 things that I’d like to write about.

Anyway, I’d been thinking about something like this for a while, because being able to understand¬† which part of a query generates which part of a query plan can help you focus in on what you need to work on. It’s also helpful to understand how different aspects of your database design and written queries might manifest in query plans.

You know, for performance.

Anyway, I hope you enjoy it. This post will be remarkably empty on first read, but will populate over time.

Thanks for reading!



2 thoughts on “Common Query Plan Patterns: Introduction And Index

  1. Sounds great! This is something you can hardly find in any blog posts / presentations / webinars etc. Maybe, there is a reason for it. Maybe, I am just following wrong sources or I am bad at googeling…Anyway, good luck and I’m so looking forward to it.

    1. They’re hard posts to write. I made a list, and while writing them each topic seems to end up as multiple posts. I understand why no one is jumping at the idea.

Leave a Reply

Your email address will not be published. Required fields are marked *