9951 explained code solutions for 126 technologies


clickhouseHow to optimize a table


Warning. This query can take a lot of time and resources for large tables.

OPTIMIZE TABLE tblctrl + c
OPTIMIZE TABLE

will optimize table data for the selected table

tbl

name of the table to optimize