Something interesting I just noticed:

If I create a file and resize it to 64bit and then create alternate keys
(with CREATE.INDEX) the alternate key file (I_filename/INDEX.000) is
also created as 64bit.

BUT, if I add the alternate keys BEFORE resizing to 64bit, the AK file
is left as a 32bit file.

As a 64bit file, the data portion can now contain many, many more
records than a 32bit file. So if the file has a number of different
alternate keys, it could be possible to blow the size of the INDEX.000
file.

So, I guess it may be best to delete and re-create the AKs after
converting to 64bit. Thoughts?

Adrian





DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to