Hi Dave: You cannot get any lower than one percent. If you set your block size to 2K that will fix the split problem making about 6%. Your average record size is 1537 which means you will get about one record per block so split by key will be worthless and you will be into Level 2 and/or Level 1 overflow.
I have found if you spend a lot of time on one file try to optimize it, then you had 100K worth of records to the file and your work is does not matter. What you want to do is get the file in best shape you can considering growth and usability, then look at this file or all your files in a week or month and see what has happened. Regards, Doug www.u2logic.com "XLr8Resizer for fast resizing" _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
