OPTIMIZE

From Recital Documentation Wiki
Revision as of 13:30, 13 January 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Purpose

Physically order a table by its primary key


Syntax

OPTIMIZE [ALL | DATABASE] [PACK]


See Also

DELETE, INDEX, OPEN DATABASE, PACK, SET ORDER, SORT, USE


Description

The OPTIMIZE command is used physically order a table by its primary key to optimize performance when reading rows from the table. If the optional PACK keyword is specified then deleted rows are removed from the table during the optimization process. The optional ALL keyword can be specified to optimize all open tables or the optional DATABASE key word can used to optimize all tables in a specified database. The table being optimized must have a primary key.


Example

open database southwind
optimize database pack


Products

Recital Server, Recital