Difference between revisions of "OPTIMIZE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
{{YLM to do}} | {{YLM to do}} | ||
| + | |||
| + | OPTIMIZE | ||
| + | |||
| + | |||
| + | |||
| + | This new command is used optimize a table by it's primary key. The table is physically ordered by the specified primary key to give better 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. | ||
Revision as of 16:06, 30 October 2009
OPTIMIZE
This new command is used optimize a table by it's primary key. The table is physically ordered by the specified primary key to give better 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.
