Administrative SQL statements

Supported Administrative SQL statements

ClustrixDB supports the following administrative SQL statements, though output may vary:

ANALYZE TABLE
EXPLAIN and EXPLAIN REFERENCED
OPTIMIZE TABLE
- ClustrixDB supports the syntax for OPTIMIZE TABLE, but does not perform any operation. ClustrixDB uses background processes to automatically optimize storage.
REPAIR TABLE
SHOW BINARY LOGS
SHOW CHARACTER SET (with no WHERE clause)
SHOW COLLATION
SHOW COLUMNS
SHOW CREATE [DATABASE | TABLE | FUNCTION | TRIGGER | SEQUENCE | VIEW]
SHOW DATABASES
SHOW ENGINES
- For compatibility, ClustrixDB lists InnoDB as part of the output of SHOW ENGINES, but the Clustrix engine will always be applied.
- Not all engines are listed as output of SHOW. See ENGINES for more information.
SHOW GRANTS
SHOW INDEX
SHOW MASTER STATUS
SHOW OPEN TABLES
SHOW PROCESSLIST
SHOW SLAVE HOSTS
SHOW STATUS
SHOW TABLES
SHOW TRIGGER
SHOW WARNINGS
- The syntax for SHOW WARNINGS is supported, but no warnings are ever displayed.
SHOW VARIABLES

ClustrixDB does not support: