Execution path of a query ?

[arvindn]

Is it possible to see the execution path taken by a query and if so , how ?

 

[dcx693]

What exactly do you mean?

 

[Pat Hartman]

Here's instructions from the Microsoft Jet Programmer's guide. They are for Jet 3.5 but may work for other versions. I don't know if this also works for Jet tables.

Tracing SQL Operations
“If you want to get a better picture of the SQL statements that Microsoft Jet sends to the remote database server through ODBC, you can trace the SQL operations. To enable SQL tracing, create a TraceSQLMode setting in the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\ODBC key in the Windows Registry and set the value to 1. When you close and restart Microsoft Jet, the engine will log all ODBC calls in the text file Sqlout.txt which is created in the current directory on your hard disk.
Jet always appends new SQL statements to the file while TraceSQLMode is enabled. If you want to disable SQL logging, set the value of TraceSQLMode to 0 and restart Microsoft Jet.”

 

[arvindn]

Thanks.

To clarify what i want further and my purpose, lets say i have a saved query in Access

select ..... from .... where .... group by ..... having .....

Can i know, which tables will have all their records read for this query's execution ?