Optimizing your AccuZIP6 Database will significantly enhance the speed of processing. With AccuZIP6, you can determine the extent of optimization with check boxes.
From the Special menu, choose Optimize Database.
The Optimize Database window will appear.
Determine the extent of optimization by checking or unchecking each check box as listed below:
Delete blank records
* Searches the database for blank records and tags the record for deletion.
Delete foreign records
* Looks in the ZIP field and searches for any ZIP code that begins with a letter and tags the record for deletion.
Pack database
* Permanently removes all records that have been tagged for deletion from the database.
Resize field widths
* Analyzes the data in each field and determines the longest value then reduces each field length to the minimum size necessary to hold the respective information. Also resizes any field that has a required length to the required width. For example, it resizes the ZIP field to a width of 10.
Order database for optimum performance
* Permanently sorts the database by 5-digit ZIP code, city and address to increase performance during Validation and Presort.
Rebuild # indexes
* AccuZIP6 creates indexes during processing. The indexes are stored so that they do not have to be recreated each time you repeat a process. For instance, if you were to choose By Company from the Sort menu, AccuZIP6 would create an index for sorting your list by company. All indexes are deleted during optimization. If you would like the program to rebuild the indexes that you have already created during processing check this box.
Click Optimize.
For more information on deleting records or tagging records for deletion see Deleting Records.