The Microsoft Jet query engine implements a cost-based query optimizer. When a query is compiled, the query engine creates a plan of execution. This plan is used internally to find the quickest way to execute a query. This information is not exposed to the user of Microsoft Jet. However, you can add and use the JETSHOWPLAN setting in the registry to cause the engine to create a text file that contains the query execution plans.