We are running UniData 5.2 on AIX 4.3.2. I have defined 16 alternate indices on a file.
I have always ASSUMED (why?) that when a record is written that all indices are updated, even when values have not changed. I have run into some index behavior that shows that I am mistaken and that the index code includes such efficiencies that the index process doesn't bother looking at values that do not change. When I do a select on any of the fields that would be set a record creation I fail to find a set of six sequential records. I assume that the index was disabled during that time (presumably by me :( ) However, when I search on fields, such as the invoice date, that would have been updated later I do find the records I expect. I will now write a process to compare the records that I get with one of the indices set on record creation with the set of all records so that the accountants can reconcile their reports. Karjala ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
