Pinned topic Update Where Current of
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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 110000D4XK3129 Posts
Re: Update Where Current of2013-02-01T19:07:18ZThis is the accepted answer. This is the accepted answer.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.