Throwback Thursday: June 20, 2024
Today's edition of Throwback Thursday is all about query tuning in Microsoft Access.

With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
This week, we dig into the vault for one of my most thorough deep dives on a little-known tool for debugging query performance in Microsoft Access: Jet Show Plan. The tool is most effective when working with back-end data stored in Access, but can be used with other back-ends, too.

And, if you've got an hour to kill and nothing better to do, here's a presentation I gave to the Denver Area Access User Group on several different techniques you can use to tune query performance in Microsoft Access:

Wisdom from Around the Web
Query optimization tips from the legendary Allen Browne:

Developer Humor
A DBA walks into a bar, sits by himself at a table, and says, "Mind if I join you?"
I'll show myself out now...
Cover image generated by Ideogram