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

[Lieven De Foor]

Hi, The documentation states the following: TABLE-SCAN provides the most efficient access method when retrieving all rows of a temp-table or a database table in a Type II Storage area. TABLE-SCAN returns these rows without using an index. When the TABLE-SCAN keyword is used, the AVM only accesses the record block instead of both record and index blocks. Am I correct in assuming that using TABLE-SCAN to delete all records from a table has no benefit over using the primary index, since the index entry needs to be removed as well?

Continue reading...