clickhouseHow to optimize a table
Warning. This query can take a lot of time and resources for large tables.
OPTIMIZE TABLE tblctrl + cOPTIMIZE TABLEwill optimize table data for the selected table | tblname of the table to optimize |
Usage example
OPTIMIZE TABLE tbloutput
OPTIMIZE TABLE tbl
Query id: 5647f3a4-4ffa-4bdf-8054-646f24c68a2a
Ok.
0 rows in set. Elapsed: 2.887 sec.More of Clickhouse
- Convert array to rows
- Get total database size
- How to execute SQL query from a file
- How to restart Clickhouse server
- Select where date column is between dates
- List all tables from all database
- Select sumIf query example
- Convert array to string
- Using variables in queries
- Select countIf usage example
See more codes...