I would check the 'set exact' setting and the index expression for starter.

Also a comment on your code, there is no need to issue 'select table1' before 'delete' and in case of 'no find' because it is still selected.