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

  • Thread starter Thread starter Tim Kuehn
  • Start date Start date
Status
Not open for further replies.
T

Tim Kuehn

Guest
The difference is the ordering - table scan (I believes) goes by rowid order which generally means faster access because successive blocks'll be "closer" to each other. Going by primary index can be an issue if the blocks are not "close" to each other and the engine has to go looking all over the place for them.

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