[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: A hundred million rows?

Status
Not open for further replies.
G

gus bjorklund

Guest
> On Jan 22, 2020, at 7:29 AM, George Potemkin wrote: > > Update from Progress Community > > George Potemkin > > If I understand correctly, the activity of idxactivate consists of: > 1. Record reads using a base index (“useindex”); > 2. Index key reads from the uncompleted tree of the activated index; > 3. Creating in memory the recovery notes for the index blocks. > note on 1: mostly sequential if reference index matches storage order note on 2: random reads not sequnential 4. creating index entry in new index 5. writing modified index blocks to disk

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