Execution Plan

[Mike Labosh]

In the Query Analyzer utility that ships with SQL Server, there is a feature
that shows the execution plan that the optimizer chose to run the query. I
have never heard of any similar feature in Access. Does anyone know of a
utility that can be used with access to accomplish this?

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!

 

['69 Camaro]

Hi, Mike.

Jet can provide this for you if you don't mind making a Windows Registry
change. Please see the following Web page for instructions on JETSHOWPLAN:

http://builder.com.com/5100-6388-5064388.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Allen Browne]

See:
http://msdn.microsoft.com/archive/d...MicrosoftAccessMicrosoftJetDatabaseEngine.asp

That reference is actually for A97, but the ShowPlan does apply to more
recent versions, as confirmed by:
http://support.microsoft.com/?id=240434

 

[Mike Labosh]

http://builder.com.com/5100-6388-5064388.htmlAwesome!

--- Console ---

- Inputs to Query -
ODBC table 'SampleSourceProfiling'
ODBC table 'CompanyLocation'
Using index 'CompanyLocationPK'
Having Indexes:
CompanyLocationPK 1188239 entries, 2632 pages, 1188239 values
which has 1 column, fixed, unique, clustered and/or counter,
primary-key, no-nulls
CompanyLocationLanguageKeyIX 1188239 entries, 2632 pages, 297060 values
which has 1 column, fixed
ODBC table 'PhoneNumber'
Using index 'PhoneNumberPK'
Having Indexes:
PhoneNumberPK 1494887 entries, 1072 pages, 1494887 values
which has 1 column, fixed, unique, clustered and/or counter,
primary-key, no-nulls
IX_PhoneNumber 1494887 entries, 1072 pages, 373722 values
which has 4 columns, fixed
ODBC table 'CompanyLocationPhoneNumber'
- End inputs to Query -

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!