Execution Plan

M

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!
 
M

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!
 
Top