Difference between revisions of "OPTIMIZE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ==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 the currently open database. The table being optimized must have a primary key. | ||
| + | |||
| + | |||
| + | ==Example== | ||
| + | <code lang="recital"> | ||
| + | open database southwind | ||
| + | optimize database pack | ||
| + | </code> | ||
| + | |||
| + | |||
| + | ==Products== | ||
| + | Recital Server, Recital | ||
| + | [[Category:Documentation]] | ||
| + | [[Category:Commands]] | ||
| + | [[Category:Table Basics]] | ||
| + | [[Category:Table Basics Commands]] | ||
Latest revision as of 11:46, 11 October 2010
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 the currently open database. The table being optimized must have a primary key.
Example
open database southwind optimize database pack
Products
Recital Server, Recital
