Regenerating database keys

Database keys provide efficient, organized access to records in a table. The keys define a hierarchical tree of indexes associated with the actual data records. Regenerating database keys discards and then regenerates the existing index tree for a table. The regeneration process examines each data record in the table and then adds indexes to the new index tree for each record. Key regeneration is a time-consuming process that can take up to several hours on large databases and is only necessary for IR keys.

Note  When regenerating the keys to a file, ensure that other users are not accessing the file. The regeneration process will interrupt all activity in progress on the file being regenerated.

Related topics

Resetting a database table

Regenerate database keys
Regenerate IR keys
Regen a database dictionary
Reset a database table from Database Manager
Schedule a regeneration
Schedule a reset