mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
8 lines
540 B
SQL
8 lines
540 B
SQL
OPTIMIZE TABLE table DEDUPLICATE; -- all columns
|
|
OPTIMIZE TABLE table DEDUPLICATE BY *; -- excludes MATERIALIZED and ALIAS columns
|
|
OPTIMIZE TABLE table DEDUPLICATE BY colX,colY,colZ;
|
|
OPTIMIZE TABLE table DEDUPLICATE BY * EXCEPT colX;
|
|
OPTIMIZE TABLE table DEDUPLICATE BY * EXCEPT (colX, colY);
|
|
OPTIMIZE TABLE table DEDUPLICATE BY COLUMNS('column-matched-by-regex');
|
|
OPTIMIZE TABLE table DEDUPLICATE BY COLUMNS('column-matched-by-regex') EXCEPT colX;
|
|
OPTIMIZE TABLE table DEDUPLICATE BY COLUMNS('column-matched-by-regex') EXCEPT (colX, colY); |