[progress Communities] [progress Openedge Abl] Forum Post: Re: 11.5.1 For Each Table-scan:...

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> I just hit another problem using this code, the deletion was dramatically slow. TABLE-SCAN reads all RM blocks owned by table. DELETE statement does not release RM blocks. RM blocks without records will be kept on RM chain (btw, the bocks with most recent deletes will be most likely added to the chain's bottom). Your "outer" query will read these blocks over and over.

Continue reading...
 
Status
Not open for further replies.
Back
Top