Easier way to add new Index only tables in MAKEDB - E4000013 - 18 Aug 2000

When you add an Index Only table with MAKEDB, the MAKELINK process creates an "update" index for every table that the new index can index. On a large database this is very inconvenient, as you most probably only want to index one or two tables with the new index.

The new version of MAKEDB accepts a new command tail -NONEWINDEX . When this is specified any new indexes that can be created as a result of adding new index only tables (or indeed any other kind of change), are left with the "update" option turned off. You then use SETLINK to turn the index on for the tables where it is required.

MAKELINK, and COPYDB also accept this command tail. It may be useful with COPYDB if two separate databases are being merged into a single structure.

DP4 Version Compatibility

4.5xx,4.6xx

Downloads

4.522/618 MAKEDB,MAKELINK,COPYDB.

(These files are likely to be superseded further planned changes to these programs in the fairly near future).