[progress Communities] [progress Openedge Abl] Forum Post: Re: Table-scan - Useless When...

[Lieven De Foor]

Hi Laura, That was more or less what I was thinking. I did not think going through the index would be faster, I did however think using TABLE-SCAN would only be marginally faster (if at all) because of the work the DELETE will cause (i.e. get the corresponding index entries and delete those). Like you said, the same work has to be done, which leads me to believe TABLE-SCAN is of little use when deleting records... Guess I'll have to write some benchmarks...

Continue reading...