[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Compare SQL query with ABL query, usage of the indexes

  • Thread starter Thread starter gus bjorklund
  • Start date Start date
Status
Not open for further replies.
G

gus bjorklund

Guest
note that aside from the ordering available by the key. each index can have a radically different i/o cost, as much as 500 to 1 difference, depending on the blocks where the rows are stored as well as the (less important) seek time between index blocks. this cost should be measured (probably again when significant changes happen to storage arrangement) on each deployed system.

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