> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ExecuteSqlRequest.Options

> ExecuteSqlRequest.Options — Kinetica Java API

<div className="kinetica-javadoc">
  <div className="header">
    <div className="sub-title"><span className="package-label-in-type">Package</span> <a href="/content/api/java/com/gpudb/protocol/package-summary">com.gpudb.protocol</a></div>
    <h1 title="Class ExecuteSqlRequest.Options" className="title">Class ExecuteSqlRequest.Options</h1>
  </div>

  <div className="inheritance" title="Inheritance Tree">
    <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">java.lang.Object</a>
    <div className="inheritance">com.gpudb.protocol.ExecuteSqlRequest.Options</div>
  </div>

  <div className="section class-description" id="class-description">
    <div className="dl notes">
      <div className="dt">Enclosing class:</div>
      <div className="dd"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public static final class </span><span className="element-name type-name-label">ExecuteSqlRequest.Options</span> <span className="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></span></div>

    <div className="block">
      A set of string constants for the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol"><code>ExecuteSqlRequest</code></a> parameter <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest#getOptions()"><code>options</code></a>.
      <p> Optional parameters.</p>
    </div>
  </div>

  <div className="section summary">
    <ul className="summary-list">
      <li>
        <div className="section field-summary" id="field-summary">
          <h2>Field Summary</h2>
          <div className="caption"><span>Fields</span></div>

          <div className="summary-table three-column-summary">
            <div className="table-header col-first">Modifier and Type</div>
            <div className="table-header col-second">Field</div>
            <div className="table-header col-last">Description</div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#COST_BASED_OPTIMIZATION" className="member-name-link">COST\_BASED\_OPTIMIZATION</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#FALSE"><code>FALSE</code></a>, disables the cost-based optimization of the given query.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#CURRENT_SCHEMA" className="member-name-link">CURRENT\_SCHEMA</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#DISTRIBUTED_JOINS" className="member-name-link">DISTRIBUTED\_JOINS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, enables the use of distributed joins in servicing the given query.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#DISTRIBUTED_OPERATIONS" className="member-name-link">DISTRIBUTED\_OPERATIONS</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, enables the use of distributed operations in servicing the given query.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#FALSE" className="member-name-link">FALSE</a></code></div>
            <div className="col-last even-row-color"> </div>
            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#IGNORE_EXISTING_PK" className="member-name-link">IGNORE\_EXISTING\_PK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Specifies the record collision error-suppression policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#FALSE"><code>FALSE</code></a>).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#LATE_MATERIALIZATION" className="member-name-link">LATE\_MATERIALIZATION</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, Joins/Filters results will always be materialized ( saved to result tables format).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PAGING_TABLE" className="member-name-link">PAGING\_TABLE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">When specified (or <a href="#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a> is set), the system will create a paging table to hold the results of the query, when the output has more records than are in the response (i.e., when <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.HasMoreRecords#TRUE"><code>TRUE</code></a>).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PAGING_TABLE_TTL" className="member-name-link">PAGING\_TABLE\_TTL</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PARALLEL_EXECUTION" className="member-name-link">PARALLEL\_EXECUTION</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#FALSE"><code>FALSE</code></a>, disables the parallel step execution of the given query.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PLAN_CACHE" className="member-name-link">PLAN\_CACHE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#FALSE"><code>FALSE</code></a>, disables plan caching for the given query.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PREPARE_MODE" className="member-name-link">PREPARE\_MODE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, compiles a query into an execution plan and saves it in query cache.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PRESERVE_DICT_ENCODING" className="member-name-link">PRESERVE\_DICT\_ENCODING</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, then columns that were dict encoded in the source table will be dict encoded in the projection table.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#QUERY_PARAMETERS" className="member-name-link">QUERY\_PARAMETERS</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Query parameters in JSON array or arrays (for inserting multiple rows).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#RESULTS_CACHING" className="member-name-link">RESULTS\_CACHING</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#FALSE"><code>FALSE</code></a>, disables caching of the results of the given query.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#RULE_BASED_OPTIMIZATION" className="member-name-link">RULE\_BASED\_OPTIMIZATION</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#FALSE"><code>FALSE</code></a>, disables rule-based rewrite optimizations for the given query.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#SSQ_OPTIMIZATION" className="member-name-link">SSQ\_OPTIMIZATION</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#FALSE"><code>FALSE</code></a>, scalar subqueries will be translated into joins.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#TRUE" className="member-name-link">TRUE</a></code></div>
            <div className="col-last odd-row-color"> </div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#TTL" className="member-name-link">TTL</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#UPDATE_ON_EXISTING_PK" className="member-name-link">UPDATE\_ON\_EXISTING\_PK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Specifies the record collision policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#VALIDATE_CHANGE_COLUMN" className="member-name-link">VALIDATE\_CHANGE\_COLUMN</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">When changing a column using alter table, validate the change before applying it.</div>
            </div>
          </div>
        </div>
      </li>

      <li>
        <div className="section method-summary" id="method-summary">
          <h2>Method Summary</h2>

          <div className="inherited-list">
            <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></h3>
            <code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" className="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" className="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" className="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" className="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" className="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" className="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" className="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" className="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" className="external-link">wait</a></code>
          </div>
        </div>
      </li>
    </ul>
  </div>

  <div className="section details">
    <ul className="details-list">
      <li>
        <div className="section field-details" id="field-detail">
          <h2>Field Details</h2>

          <ul className="member-list">
            <li>
              <div className="section detail" id="COST_BASED_OPTIMIZATION">
                <h3>COST\_BASED\_OPTIMIZATION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">COST\_BASED\_OPTIMIZATION</span></div>

                <div className="block">
                  If <a href="#FALSE"><code>FALSE</code></a>, disables the cost-based optimization of the given query. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.COST_BASED_OPTIMIZATION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUE">
                <h3>TRUE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUE</span></div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.TRUE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="FALSE">
                <h3>FALSE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">FALSE</span></div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.FALSE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="DISTRIBUTED_JOINS">
                <h3>DISTRIBUTED\_JOINS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">DISTRIBUTED\_JOINS</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.DISTRIBUTED_JOINS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="DISTRIBUTED_OPERATIONS">
                <h3>DISTRIBUTED\_OPERATIONS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">DISTRIBUTED\_OPERATIONS</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.DISTRIBUTED_OPERATIONS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="IGNORE_EXISTING_PK">
                <h3>IGNORE\_EXISTING\_PK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">IGNORE\_EXISTING\_PK</span></div>

                <div className="block">
                  Specifies the record collision error-suppression policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#FALSE"><code>FALSE</code></a>). If set to <a href="#TRUE"><code>TRUE</code></a>, any record insert/update that is rejected for resulting in a primary key collision with an existing table record will be ignored with no error generated. If <a href="#FALSE"><code>FALSE</code></a>, the rejection of any insert/update for resulting in a primary key collision will cause an error to be reported. If the specified table does not have a primary key or if <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>, then this option has no effect. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a>: Ignore inserts/updates that result in primary key collisions with existing records. </li>
                    <li><a href="#FALSE"><code>FALSE</code></a>: Treat as errors any inserts/updates that result in primary key collisions with existing records. </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.IGNORE_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="LATE_MATERIALIZATION">
                <h3>LATE\_MATERIALIZATION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">LATE\_MATERIALIZATION</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, Joins/Filters results will always be materialized ( saved to result tables format). Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.LATE_MATERIALIZATION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PAGING_TABLE">
                <h3>PAGING\_TABLE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PAGING\_TABLE</span></div>
                <div className="block">When specified (or <a href="#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a> is set), the system will create a paging table to hold the results of the query, when the output has more records than are in the response (i.e., when <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.HasMoreRecords#TRUE"><code>TRUE</code></a>). If the specified paging table exists, the records from the paging table are returned without re-evaluating the query. It is the caller's responsibility to clear the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) when they are done with this query.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.PAGING_TABLE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PAGING_TABLE_TTL">
                <h3>PAGING\_TABLE\_TTL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PAGING\_TABLE\_TTL</span></div>
                <div className="block">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. -1 indicates no timeout. Setting this option will cause a paging table to be generated when needed. The <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) will be automatically cleared after the TTL expires, if set to a positive number. However, it is still recommended that the caller clear these tables when they are done with this query.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.PAGING_TABLE_TTL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PARALLEL_EXECUTION">
                <h3>PARALLEL\_EXECUTION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PARALLEL\_EXECUTION</span></div>

                <div className="block">
                  If <a href="#FALSE"><code>FALSE</code></a>, disables the parallel step execution of the given query. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.PARALLEL_EXECUTION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PLAN_CACHE">
                <h3>PLAN\_CACHE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PLAN\_CACHE</span></div>

                <div className="block">
                  If <a href="#FALSE"><code>FALSE</code></a>, disables plan caching for the given query. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.PLAN_CACHE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PREPARE_MODE">
                <h3>PREPARE\_MODE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PREPARE\_MODE</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.PREPARE_MODE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PRESERVE_DICT_ENCODING">
                <h3>PRESERVE\_DICT\_ENCODING</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PRESERVE\_DICT\_ENCODING</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.PRESERVE_DICT_ENCODING">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="QUERY_PARAMETERS">
                <h3>QUERY\_PARAMETERS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">QUERY\_PARAMETERS</span></div>
                <div className="block">Query parameters in JSON array or arrays (for inserting multiple rows). This can be used instead of <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest#getData()"><code>data</code></a> and <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest#getRequestSchemaStr()"><code>requestSchemaStr</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.QUERY_PARAMETERS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RESULTS_CACHING">
                <h3>RESULTS\_CACHING</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">RESULTS\_CACHING</span></div>

                <div className="block">
                  If <a href="#FALSE"><code>FALSE</code></a>, disables caching of the results of the given query. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.RESULTS_CACHING">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RULE_BASED_OPTIMIZATION">
                <h3>RULE\_BASED\_OPTIMIZATION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">RULE\_BASED\_OPTIMIZATION</span></div>

                <div className="block">
                  If <a href="#FALSE"><code>FALSE</code></a>, disables rule-based rewrite optimizations for the given query. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.RULE_BASED_OPTIMIZATION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="SSQ_OPTIMIZATION">
                <h3>SSQ\_OPTIMIZATION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">SSQ\_OPTIMIZATION</span></div>

                <div className="block">
                  If <a href="#FALSE"><code>FALSE</code></a>, scalar subqueries will be translated into joins. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.SSQ_OPTIMIZATION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TTL">
                <h3>TTL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TTL</span></div>
                <div className="block">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.TTL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="UPDATE_ON_EXISTING_PK">
                <h3>UPDATE\_ON\_EXISTING\_PK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">UPDATE\_ON\_EXISTING\_PK</span></div>

                <div className="block">
                  Specifies the record collision policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="#TRUE"><code>TRUE</code></a>, any existing table record with primary key values that match those of a record being inserted or updated will be replaced by that record. If set to <a href="#FALSE"><code>FALSE</code></a>, any such primary key collision will result in the insert/update being rejected and the error handled as determined by <a href="#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a>. If the specified table does not have a primary key, then this option has no effect. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a>: Replace the collided-into record with the record inserted or updated when a new/modified record causes a primary key collision with an existing record. </li>
                    <li><a href="#FALSE"><code>FALSE</code></a>: Reject the insert or update when it results in a primary key collision with an existing record. </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.UPDATE_ON_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="VALIDATE_CHANGE_COLUMN">
                <h3>VALIDATE\_CHANGE\_COLUMN</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">VALIDATE\_CHANGE\_COLUMN</span></div>

                <div className="block">
                  When changing a column using alter table, validate the change before applying it. If <a href="#TRUE"><code>TRUE</code></a>, then validate all values. A value too large (or too long) for the new type will prevent any change. If <a href="#FALSE"><code>FALSE</code></a>, then when a value is too large or long, it will be truncated. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.VALIDATE_CHANGE_COLUMN">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="CURRENT_SCHEMA">
                <h3>CURRENT\_SCHEMA</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">CURRENT\_SCHEMA</span></div>
                <div className="block">Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.ExecuteSqlRequest.Options.CURRENT_SCHEMA">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>