Home page  
Help >
DDL Command CONSTRUCT
Version 7.11
DDL Command CONSTRUCT

CONSTRUCT

The CONSTRUCT command builds the internal indexes for keyed fields. Keyed fields are used by FIND and MATCH.

Notation standards Options Answers

Syntax:
                CONSTRUCT/options [tablename] [fieldname]

Options:
                X             -Suppress the command response
                Y             -Do not alter the command answer cells

Answers:
                Ctl.Ans1                =Zero
                Ctl.Ans2                =Zero
                Ctl.Ans3                =Zero

Notes:
If you have a table with just a couple of hundred records in it, you do not need to bother declaring local fields (fields that are known only in that table, i.e., not global) as keys, as FIND and MATCH will work with non-key fields also. And with just a couple of hundred records, they will be fast enough. But for global keys and tables with a larger population of records, you do want to declare fields that will be used in queries as keys, and build indexes for them so that FIND and MATCH will respond quickly.

After you have LOADed new data into your database, you must use either CONSTRUCT or STRUCTURE to build the indexes for fields declared as keys.

Unless you have some very specific needs, you almost never need to use the CONSTRUCT command because the STRUCTURE command will do the same thing, and it will do it much faster. See the STRUCTURE command description.

Examples

                CONSTRUCT

builds key index structure for every keyed field in the data base. The STRUCTURE command will do this job much faster.

                CONSTRUCT CUSTOMERS

builds key index structure for all the keyed fields in the CUSTOMERS table. The STRUCTURE command has no table-specific capability so it does not do this.

                CONSTRUCT CUST#

builds key index structure for the CUST# field in every table where it is a key. The STRUCTURE command will do this job much faster.

                CONSTRUCT CUSTOMERS CUST#

builds key index structure for the CUST# field just in the CUSTOMERS table. The STRUCTURE command does not do this because it has no ability to be table specific.

Copyright © 2019 , WhamTech, Inc.  All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Names may be trademarks of their respective owners.