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

  • Thread starter Thread starter Lieven De Foor
  • Start date Start date
Status
Not open for further replies.
L

Lieven De Foor

Guest
Hi Tim, You don't have to convince me TABLE-SCAN is the fastest way of reading all records when the order isn't important. I completely understand the principle here ;-) It is the special case of deleting a record that makes me wonder if the benefit is still there, since at that point the engine needs to find all index entries for all indexes pointing to that record too, and finding these might negate the performance benefit of TABLE-SCAN...

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