I'm using an access database, and I'm monitoring it using showplan.out
.
I'm trying to figure out which field in which table a certain checkbox applies to. (I can't look at the form so don't ask)
I start monitoring; change the value of a checkbox; click save; and then stop.
Then I start monitoring again; change the value of the same checkbox, click save; and stop monitoring.
To my surprise both showplan.out
files are identical (I did a diff), and neither of them have the value -1
in them, as vba checkboxes usually indicate.
All of the queries in question are marked as --- temp query ---
.
Assuming that the GUI form uses SQL UPDATE
to change the value the checkbox value, what would that look like in showplan.out
?
I've seen a few things in showplan.out
that kind of look like it is checking the Primary key to see if it can fit another record in the table with distinct values, but I'm still a unsure of what constitutes an UPDATE
or an INSERT
here:
--- temp query ---
- Inputs to Query -
Table 'T_SkillLevelGroups'
Database 'E:\XXX\xVisitrax_BE.mdb'
Table 'T_SkillLevelGroups_Map'
Database 'E:\XXX\xVisitrax_BE.mdb'
Using index 'slg_Key'
Having Indexes:
slg_Key 4007 entries, 7 pages, 10 values
which has 1 column, fixed
PrimaryKey 4007 entries, 8 pages, 4007 values
which has 1 column, fixed, unique, clustered and/or counter, primary-key, no-nulls
- End inputs to Query -
01) Restrict rows of table T_SkillLevelGroups
by scanning
testing expression "T_SkillLevelGroups.slg_GroupName In ("ZZZ","XXXX")"
02) Inner Join result of '01)' to table 'T_SkillLevelGroups_Map'
using index 'T_SkillLevelGroups_Map!slg_Key'
join expression "T_SkillLevelGroups.slg_Key=T_SkillLevelGroups_Map.slg_Key"
then test expression "slgm_SkillLevel='someskill'"