Topic
  • 2 replies
  • Latest Post - ‏2013-02-04T14:50:23Z by ZachJ
ZachJ
ZachJ
15 Posts

Pinned topic Update Where Current of

‏2013-02-01T18:43:11Z |
I am doing an embedded SQL positioned update in RPG using SET ROW. When I look a the plan cache it is telling me that it's doing a table scan on that statement with a reason code of "Indexes do not match". Is it really doing a table scan or does it just show up that way in the plan cache?
Updated on 2013-02-04T14:50:23Z at 2013-02-04T14:50:23Z by ZachJ
  • SystemAdmin
    SystemAdmin
    3129 Posts

    Re: Update Where Current of

    ‏2013-02-01T19:07:18Z  
    For WHERE CURRENT OF, the plan will always show up as a TableScan. The database manager will do a position by RRN to implement the WHERE CURRENT OF, so it is not actually scanning the whole table.
  • ZachJ
    ZachJ
    15 Posts

    Re: Update Where Current of

    ‏2013-02-04T14:50:23Z  
    For WHERE CURRENT OF, the plan will always show up as a TableScan. The database manager will do a position by RRN to implement the WHERE CURRENT OF, so it is not actually scanning the whole table.
    Great, thanks for the info!