[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Table reads versus index reads

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

gus bjorklund

Guest
1 index read for index root block, 1 index read for the leaf block to locate the record with key value "def", 1 index read of leaf block on next iteration of for each to determine that there are no more matches. note that if the current cursor is at the last entry in a leaf block, the an additional read of root block will be needed to read the next leaf block, so that can sometimes add 2 more reads, depending on index type and query.

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