[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: what do y'all think about through put

  • Thread starter Thread starter Richard Banville
  • Start date Start date
Status
Not open for further replies.
R

Richard Banville

Guest
I could not agree more Tom. For large volumes, physical order of data for scanning as well as logical order of data for the index building portion can produce dramatic differences in performance results. This is likely why a separate index rebuild is often faster than building indexes inline and visa versa. If sorting is not needed, it is probably faster to do inline. If sorting is needed, it Is likely faster to index rebuild separately.

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