S
ske
Guest
marian.edu wrote: > it’s all about some kind of ‘optimisation’ on index creation… > no idea if it’s only for temp-tables or same holds true for database tables. I have since a long time had the impression that each index is individually written to storage when all the fields of that index have been set, or the buffer is released, even for regular database tables. And only those indexes that have been written to storage can be found by other users or procedures, from that point in time. (And you need to use NO-LOCK to test this on regular tables.) Usually, when you assign all fields in a single statement, or release it shortly after, you don't notice the difference, but if you do it one field at a time and don't release, it becomes more apparent. (I don't remember if there was any difference between the primary index and other indexes.) Maybe some-one from Progress can confirm or deny whether this impression is correct?
Continue reading...
Continue reading...