SQL Settings
The following SQL commands affect the current session only:
SET RESULT_STRUCTURE X100
Forces WITH STRUCTURE=X100 on all CREATE TABLE, CREATE TABLE AS SELECT, and DECLARE GLOBAL TEMPORARY TABLE statements.
The default for the installation is taken from the result_structure parameter in config.dat.
SET RESULT_STRUCTURE X100_ROW
Forces WITH STRUCTURE=X100_ROW on all CREATE TABLE, CREATE TABLE AS SELECT, and DECLARE GLOBAL TEMPORARY TABLE statements.
The default for the installation is taken from the result_structure parameter in config.dat.
SET QEP
Displays a graphical version of the query plan.
SET TRACE POINT OP150
Displays the contents of the compiled query.
SET TRACE POINT QE82
Disables compression for tables.
Automatic table compression is used by default. If the dataset is small and fits into memory, disabling compression may slightly increase performance by eliminating the overhead associated with decompression.
For example:
SET TRACE POINT QE82;
CREATE TABLE...
SET NOREUSE
Disables the "reuse" heuristic of the query optimizer.
Last modified date: 01/30/2023