Subject Re: [IBO] Locate and the POS-attribute
Author Jason Wharton
> I have seen some additional things. In the first case, without the
> POS-attribute, there are nearly 7000 rows in the buffer. This is the
> as expected, the locate-method walks through the buffer until it has found
> record. In this case, the record is the last one, so it has to fetch all
> into the buffer.
> But in the second case, with the POS-attribute, there are only 12 rows in
> buffer. Can anybody explain me, how the locate-method has found the record
> fast ?

Read about horizontal dataset refinement.

In short, the dataset is maintained by bi-directional cursors instead of a
single unidirectional cursor.

Jason Wharton
CPS - Mesa AZ