JetShowPlan.out OtuPut

[gkl]

Dear All, I am using JetShowPlan on Access2013 running on Windows 7 (64-bit) and I enabled JetShowPlan. I have a table called User with id, first_name, last_name, email and country fields. The field country has an index defined and the others do not. I run a query with first_name and checked the output in the showplan.out file (it was empty before so the output is only by this query. The output is as follows.

--------------------------------------------- DATE: 0 VER: 15.00.4719
NOTE: Currently does not handle subqueries, vt parameters, and subqueries
NOTE: You may see ERROR messages in these cases
--- Query1 - First Name
--- - Inputs to Query
- Table 'User'
- End inputs to Query
- 01) Restrict rows of table User by scanning testing expression "User.first_name="Aaron""
--- temp query ---
- Inputs to Query
- Recordset
- End inputs to Query
- 01) Scan recordset
02) Restrict rows of table 01) using index 'IdxFKPrimaryScalar' for expression "[_Data]=FK"
--- temp query ---
- Inputs to Query
- Recordset
- End inputs to Query
- 01) Scan recordset
02) Restrict rows of table 01) using index 'IdxFKPrimaryScalar' for expression "[_Data]=FK"

(I apologise for the poor formatting, did not know how to make it appear clearer). I am puzzled by the fact that it uses the same plan twice; why would it do that? And why would it do a temp query when there is only one table? Regards, George

 

[vbaInet]

Can you reformat in Notepad and re-paste. How did you come to know about the JetShowPlan? It's a hidden feature in Access.

 

[CJ_London]

would also help if you post your query sql as well so the plan can be seen in context

 

[gkl]

Can you reformat in Notepad and re-paste. How did you come to know about the JetShowPlan? It's a hidden feature in Access.

Sure, I edited the original question and it should be fine now. As for my knowledge of JetShowPlan I was looking for a feature equivalent of explain plan for Oracle and one of the forum fellow members suggested it.

Regards,
George

 

[gkl]

would also help if you post your query sql as well so the plan can be seen in context

That was a simple

select * from user where first_name='Aaron';