Analyze Access Queries with JetShowPlan

JetShowplan is a very helpful feature of the JET/ACE-Database-Engine to analyze complex Access queries for performance tuning.
If you turn on this advance debug and tuning feature of the JET/ACE-Database-Engine, information about queried tables, their indexes and the execution plan of any query will be written to the showplan.out text file.

Thanks to Daniel Pineault for figuring out the Registry path for the Office 365 Click-To-Run-Edition of Access. https://www.devhut.net/2011/04/30/ms-access-jet-showplan/

Видео Analyze Access Queries with JetShowPlan канала codekabinett.com/en