Product Solutions Support
Try MemSQL

OPTIMIZE TABLE

This topic assumes familiarity with the concepts of columnstore table layout, including segments, row segment groups, and background mergers. For more on these topics, see Managing Columnstore Segments.

MemSQL automatically runs optimization routines on tables, but they can also be started manually.

Syntax

OPTIMIZE TABLE table_name [FULL | FLUSH];

Remarks

Optimizing Columnstore Tables

Optimizing Rowstore Tables

Was this article useful?