Does an SQL Update Look different from any other query in showplan.out?

77 Views Asked by At

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'"
0

There are 0 best solutions below