Click above to get retro games delivered to your door ever month!

REINDEX              Recreate all indexes in the current workarea
------------------------------------------------------------------------------

Synopsis

    REINDEX [EVAL <eval> [ EVERY <nEvery> ]]
            [NOOPTIMIZE]

Arguments

    If EVAL <eval> is specified, the expression represented by <eval> will
    be evaluated for each record accessed.  If the expression returns false,
    then index creation will stop;  as long as it returns true, index
    creation will continue.

    If EVERY <nEvery> is also specified, the <eval> will be evaluated every
    <nEvery>'th record (instead of every record).  The logic is the same as
    described under the INDEX command; this logic is employed for each index
    recreated.

    If NOOPTIMIZE is specified and you are using ClipMore, then the FOR
    conditions (of any indexes which have a FOR condition) will not be
    optimized.  Comix alone never optimizes the FOR condition, but
    ClipMore does optimize the FOR condition by default.  Specifying
    NOOPTIMIZE allows you to override this behavior.

Description

    The REINDEX command rebuilds all open indexes in the current work area.
    This command will also cause any free space in the .CDX to be
    reclaimed.

Example

    This example recreates all indexes in the structural index:

    use demo
    reindex

Example

    This example recreates all indexes in the structural index and FIRST.CDX
    as well as displaying progress information:

    use demo
    set index to first
    reindex eval ourUDF() every 1000

    function ourUDF()
    @ 0, 0 say str(recno()) + " Keys Generated"
    return .t.

See Also

    INDEX