7. Configuring and Managing VectorH : SQL Settings
 
Share this page                  
SQL Settings
The following SQL commands affect the current session only:
SET RESULT_STRUCTURE VECTORWISE
Forces WITH STRUCTURE=VECTORWISE 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 VECTORWISE_ROW
Forces WITH STRUCTURE=VECTORWISE_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 (see  "Reuse" Heuristic) of the query optimizer.