> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Throwback Thursday: June 20, 2024
- URL: https://nolongerset.com/throwback-thursday-2024-06-20/
- Published: 2024-06-21T03:36:07.000Z
- Updated: 2026-05-08T12:40:47.000Z
- Description: Today's edition of Throwback Thursday is all about query tuning in Microsoft Access.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*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.

[JetShowPlan: A PrimerYou may be familiar with JetShowPlan, but I guarantee you’ve never read an article about it quite like this one.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/military-raptor-582888_1920.jpg)](https://nolongerset.com/jetshowplan-a-primer/)

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:

[Troubleshooting Query PerformanceA recording of the presentation, a list of resources, and further reading for my presentation on Troubleshooting Query Performance.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/PowerPoint-Slide-Show-----Troubleshooting-Query-Performance.jpg)](https://nolongerset.com/troubleshooting-query-performance/)

## Wisdom from Around the Web

Query optimization tips from the legendary Allen Browne:

[Microsoft Access tips: Optimizing queriesHow to get JET (the database engine in Microsoft Access) to execute queries quickly![](http://allenbrowne.com/favicon.ico)![](http://allenbrowne.com/graphics/cross.png)](http://allenbrowne.com/QueryPerfIssue.html)

## 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*