|Subject||Re: [IBO] Locate and the POS-attribute|
> I have seen some additional things. In the first case, without thebehavior
> 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 foundthe
> record. In this case, the record is the last one, so it has to fetch allrecords
> into the buffer.the
> 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 recordso
> fast ?Read about horizontal dataset refinement.
In short, the dataset is maintained by bi-directional cursors instead of a
single unidirectional cursor.
CPS - Mesa AZ