> ## 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.

# kinetica.ExecuteSqlRequest.Options

> kinetica.ExecuteSqlRequest.Options — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlRequest#a291e7aa01ca44086d0a6f032d93274db" title="Optional parameters.">ExecuteSqlRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="pub-static-attribs" />

            Static Public Attributes
          </h2>
        </td>
      </tr>

      <tr className="memitem:aa4f9df8ee5fc9dfa5ad0f8cdd9303274" id="r_aa4f9df8ee5fc9dfa5ad0f8cdd9303274">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aa4f9df8ee5fc9dfa5ad0f8cdd9303274">COST\_BASED\_OPTIMIZATION</a> = "cost\_based\_optimization"</td>
      </tr>

      <tr className="memdesc:aa4f9df8ee5fc9dfa5ad0f8cdd9303274">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, disables the cost-based optimization of the given query. <br /></td>
      </tr>

      <tr className="separator:aa4f9df8ee5fc9dfa5ad0f8cdd9303274">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a95e0cc60832e386efb127176cb869cc9" id="r_a95e0cc60832e386efb127176cb869cc9">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> = "true"</td>
      </tr>

      <tr className="memdesc:a95e0cc60832e386efb127176cb869cc9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlRequest_1_1Options" title="A set of string constants for the parameter ExecuteSqlRequest.options.">ExecuteSqlRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a95e0cc60832e386efb127176cb869cc9">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a3044a4a1e8a617231f065a6d09cdb2c6" id="r_a3044a4a1e8a617231f065a6d09cdb2c6">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> = "false"</td>
      </tr>

      <tr className="memdesc:a3044a4a1e8a617231f065a6d09cdb2c6">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlRequest_1_1Options" title="A set of string constants for the parameter ExecuteSqlRequest.options.">ExecuteSqlRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a3044a4a1e8a617231f065a6d09cdb2c6">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:aff2fced546db122a40f4b75129ae75f0" id="r_aff2fced546db122a40f4b75129ae75f0">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aff2fced546db122a40f4b75129ae75f0">DISTRIBUTED\_JOINS</a> = "distributed\_joins"</td>
      </tr>

      <tr className="memdesc:aff2fced546db122a40f4b75129ae75f0">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, enables the use of distributed joins in servicing the given query. <br /></td>
      </tr>

      <tr className="separator:aff2fced546db122a40f4b75129ae75f0">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a9e976930efdbd9e029bcfb974edd4837" id="r_a9e976930efdbd9e029bcfb974edd4837">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a9e976930efdbd9e029bcfb974edd4837">DISTRIBUTED\_OPERATIONS</a> = "distributed\_operations"</td>
      </tr>

      <tr className="memdesc:a9e976930efdbd9e029bcfb974edd4837">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, enables the use of distributed operations in servicing the given query. <br /></td>
      </tr>

      <tr className="separator:a9e976930efdbd9e029bcfb974edd4837">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ab7b119e64f59f2eee87c03549533cb4b" id="r_ab7b119e64f59f2eee87c03549533cb4b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ab7b119e64f59f2eee87c03549533cb4b">IGNORE\_EXISTING\_PK</a> = "ignore\_existing\_pk"</td>
      </tr>

      <tr className="memdesc:ab7b119e64f59f2eee87c03549533cb4b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">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 className="el" href="#ad7dca9b112ec6c85faba9016360a7631">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>). <br /></td>
      </tr>

      <tr className="separator:ab7b119e64f59f2eee87c03549533cb4b">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a2cc684243bbc68aedf939980f0bee7cc" id="r_a2cc684243bbc68aedf939980f0bee7cc">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a2cc684243bbc68aedf939980f0bee7cc">LATE\_MATERIALIZATION</a> = "late\_materialization"</td>
      </tr>

      <tr className="memdesc:a2cc684243bbc68aedf939980f0bee7cc">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, Joins/Filters results will always be materialized ( saved to result tables format). <br /></td>
      </tr>

      <tr className="separator:a2cc684243bbc68aedf939980f0bee7cc">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:acffb43e4ce9ec2ca35be41ac1dac83a2" id="r_acffb43e4ce9ec2ca35be41ac1dac83a2">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#acffb43e4ce9ec2ca35be41ac1dac83a2">PAGING\_TABLE</a> = "paging\_table"</td>
      </tr>

      <tr className="memdesc:acffb43e4ce9ec2ca35be41ac1dac83a2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">When specified (or <a className="el" href="#a666b6313113f063979c8f334348baf25">PAGING\_TABLE\_TTL</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 className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlResponse#a20eef9151163bb66062111fec170af98">has\_more\_records</a> is <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlResponse_1_1HasMoreRecords#a0a29e84971e2b8c7008b81ad72bdf04f">TRUE</a>). <br /></td>
      </tr>

      <tr className="separator:acffb43e4ce9ec2ca35be41ac1dac83a2">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a666b6313113f063979c8f334348baf25" id="r_a666b6313113f063979c8f334348baf25">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a666b6313113f063979c8f334348baf25">PAGING\_TABLE\_TTL</a> = "paging\_table\_ttl"</td>
      </tr>

      <tr className="memdesc:a666b6313113f063979c8f334348baf25">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. <br /></td>
      </tr>

      <tr className="separator:a666b6313113f063979c8f334348baf25">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:af30527b820c209626c9ba5e0d553f310" id="r_af30527b820c209626c9ba5e0d553f310">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af30527b820c209626c9ba5e0d553f310">PARALLEL\_EXECUTION</a> = "parallel\_execution"</td>
      </tr>

      <tr className="memdesc:af30527b820c209626c9ba5e0d553f310">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, disables the parallel step execution of the given query. <br /></td>
      </tr>

      <tr className="separator:af30527b820c209626c9ba5e0d553f310">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a329c23df45b60aa81047a0739f8299db" id="r_a329c23df45b60aa81047a0739f8299db">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a329c23df45b60aa81047a0739f8299db">PLAN\_CACHE</a> = "plan\_cache"</td>
      </tr>

      <tr className="memdesc:a329c23df45b60aa81047a0739f8299db">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, disables plan caching for the given query. <br /></td>
      </tr>

      <tr className="separator:a329c23df45b60aa81047a0739f8299db">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a0fc4cba9894b18b482e7bb689b8305a1" id="r_a0fc4cba9894b18b482e7bb689b8305a1">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a0fc4cba9894b18b482e7bb689b8305a1">PREPARE\_MODE</a> = "prepare\_mode"</td>
      </tr>

      <tr className="memdesc:a0fc4cba9894b18b482e7bb689b8305a1">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, compiles a query into an execution plan and saves it in query cache. <br /></td>
      </tr>

      <tr className="separator:a0fc4cba9894b18b482e7bb689b8305a1">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a185f8f6e6422a5ddb8abf2c7155645db" id="r_a185f8f6e6422a5ddb8abf2c7155645db">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a185f8f6e6422a5ddb8abf2c7155645db">PRESERVE\_DICT\_ENCODING</a> = "preserve\_dict\_encoding"</td>
      </tr>

      <tr className="memdesc:a185f8f6e6422a5ddb8abf2c7155645db">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, then columns that were dict encoded in the source table will be dict encoded in the projection table. <br /></td>
      </tr>

      <tr className="separator:a185f8f6e6422a5ddb8abf2c7155645db">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a94cb8ee369be7eb92c19269dbf525ff9" id="r_a94cb8ee369be7eb92c19269dbf525ff9">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a94cb8ee369be7eb92c19269dbf525ff9">QUERY\_PARAMETERS</a> = "query\_parameters"</td>
      </tr>

      <tr className="memdesc:a94cb8ee369be7eb92c19269dbf525ff9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Query parameters in JSON array or arrays (for inserting multiple rows). <br /></td>
      </tr>

      <tr className="separator:a94cb8ee369be7eb92c19269dbf525ff9">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad290c2ba361293581332eece4b5bb386" id="r_ad290c2ba361293581332eece4b5bb386">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad290c2ba361293581332eece4b5bb386">RESULTS\_CACHING</a> = "results\_caching"</td>
      </tr>

      <tr className="memdesc:ad290c2ba361293581332eece4b5bb386">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, disables caching of the results of the given query. <br /></td>
      </tr>

      <tr className="separator:ad290c2ba361293581332eece4b5bb386">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a45349680a4f82bac547ca5c6749b77f8" id="r_a45349680a4f82bac547ca5c6749b77f8">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a45349680a4f82bac547ca5c6749b77f8">RULE\_BASED\_OPTIMIZATION</a> = "rule\_based\_optimization"</td>
      </tr>

      <tr className="memdesc:a45349680a4f82bac547ca5c6749b77f8">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, disables rule-based rewrite optimizations for the given query. <br /></td>
      </tr>

      <tr className="separator:a45349680a4f82bac547ca5c6749b77f8">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a4150c15308c08d03bd826246f3c5b9cc" id="r_a4150c15308c08d03bd826246f3c5b9cc">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a4150c15308c08d03bd826246f3c5b9cc">SSQ\_OPTIMIZATION</a> = "ssq\_optimization"</td>
      </tr>

      <tr className="memdesc:a4150c15308c08d03bd826246f3c5b9cc">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, scalar subqueries will be translated into joins. <br /></td>
      </tr>

      <tr className="separator:a4150c15308c08d03bd826246f3c5b9cc">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a347997e72b5b9128f73d60d51ec2ad98" id="r_a347997e72b5b9128f73d60d51ec2ad98">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a347997e72b5b9128f73d60d51ec2ad98">TTL</a> = "ttl"</td>
      </tr>

      <tr className="memdesc:a347997e72b5b9128f73d60d51ec2ad98">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution. <br /></td>
      </tr>

      <tr className="separator:a347997e72b5b9128f73d60d51ec2ad98">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad7dca9b112ec6c85faba9016360a7631" id="r_ad7dca9b112ec6c85faba9016360a7631">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad7dca9b112ec6c85faba9016360a7631">UPDATE\_ON\_EXISTING\_PK</a> = "update\_on\_existing\_pk"</td>
      </tr>

      <tr className="memdesc:ad7dca9b112ec6c85faba9016360a7631">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">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>. <br /></td>
      </tr>

      <tr className="separator:ad7dca9b112ec6c85faba9016360a7631">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:abeb5dac19c9b1bb8fb0b0f870baab540" id="r_abeb5dac19c9b1bb8fb0b0f870baab540">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#abeb5dac19c9b1bb8fb0b0f870baab540">VALIDATE\_CHANGE\_COLUMN</a> = "validate\_change\_column"</td>
      </tr>

      <tr className="memdesc:abeb5dac19c9b1bb8fb0b0f870baab540">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">When changing a column using alter table, validate the change before applying it. <br /></td>
      </tr>

      <tr className="separator:abeb5dac19c9b1bb8fb0b0f870baab540">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a5207cd3992c4940a2fc0b1d55fee64c2" id="r_a5207cd3992c4940a2fc0b1d55fee64c2">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5207cd3992c4940a2fc0b1d55fee64c2">CURRENT\_SCHEMA</a> = "current\_schema"</td>
      </tr>

      <tr className="memdesc:a5207cd3992c4940a2fc0b1d55fee64c2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command. <br /></td>
      </tr>

      <tr className="separator:a5207cd3992c4940a2fc0b1d55fee64c2">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <div id="details" />

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlRequest#a291e7aa01ca44086d0a6f032d93274db" title="Optional parameters.">ExecuteSqlRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L58">58</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>

    <div id="aa4f9df8ee5fc9dfa5ad0f8cdd9303274" />

    <h2 className="memtitle"><span className="permalink"><a href="#aa4f9df8ee5fc9dfa5ad0f8cdd9303274">◆ </a></span>COST\_BASED\_OPTIMIZATION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.COST\_BASED\_OPTIMIZATION = "cost\_based\_optimization"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L77">77</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a5207cd3992c4940a2fc0b1d55fee64c2" />

    <h2 className="memtitle"><span className="permalink"><a href="#a5207cd3992c4940a2fc0b1d55fee64c2">◆ </a></span>CURRENT\_SCHEMA</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.CURRENT\_SCHEMA = "current\_schema"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L427">427</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="aff2fced546db122a40f4b75129ae75f0" />

    <h2 className="memtitle"><span className="permalink"><a href="#aff2fced546db122a40f4b75129ae75f0">◆ </a></span>DISTRIBUTED\_JOINS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.DISTRIBUTED\_JOINS = "distributed\_joins"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, enables the use of distributed joins in servicing the given query. </p>
        <p>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:</p>

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L107">107</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a9e976930efdbd9e029bcfb974edd4837" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9e976930efdbd9e029bcfb974edd4837">◆ </a></span>DISTRIBUTED\_OPERATIONS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.DISTRIBUTED\_OPERATIONS = "distributed\_operations"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, enables the use of distributed operations in servicing the given query. </p>
        <p>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:</p>

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L129">129</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a3044a4a1e8a617231f065a6d09cdb2c6" />

    <h2 className="memtitle"><span className="permalink"><a href="#a3044a4a1e8a617231f065a6d09cdb2c6">◆ </a></span>FALSE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.FALSE = "false"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlRequest_1_1Options" title="A set of string constants for the parameter ExecuteSqlRequest.options.">ExecuteSqlRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L85">85</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="ab7b119e64f59f2eee87c03549533cb4b" />

    <h2 className="memtitle"><span className="permalink"><a href="#ab7b119e64f59f2eee87c03549533cb4b">◆ </a></span>IGNORE\_EXISTING\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.IGNORE\_EXISTING\_PK = "ignore\_existing\_pk"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>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 className="el" href="#ad7dca9b112ec6c85faba9016360a7631">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>). </p>
        <p>If set to <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</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 className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</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 className="el" href="#ad7dca9b112ec6c85faba9016360a7631">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>, then this option has no effect. Supported values:</p>

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

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L170">170</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a2cc684243bbc68aedf939980f0bee7cc" />

    <h2 className="memtitle"><span className="permalink"><a href="#a2cc684243bbc68aedf939980f0bee7cc">◆ </a></span>LATE\_MATERIALIZATION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.LATE\_MATERIALIZATION = "late\_materialization"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L189">189</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="acffb43e4ce9ec2ca35be41ac1dac83a2" />

    <h2 className="memtitle"><span className="permalink"><a href="#acffb43e4ce9ec2ca35be41ac1dac83a2">◆ </a></span>PAGING\_TABLE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.PAGING\_TABLE = "paging\_table"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>When specified (or <a className="el" href="#a666b6313113f063979c8f334348baf25">PAGING\_TABLE\_TTL</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 className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlResponse#a20eef9151163bb66062111fec170af98">has\_more\_records</a> is <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlResponse_1_1HasMoreRecords#a0a29e84971e2b8c7008b81ad72bdf04f">TRUE</a>). </p>
        <p>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 className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlResponse#a1f8d5ccaf2eb44e38c3ab55a6f7548ff">paging\_table</a> and other tables in the <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlResponse_1_1Info#ada58c67efefe44d1180e8d0305fe27e5">RESULT\_TABLE\_LIST</a> (both returned in the response) when they are done with this query. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L207">207</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a666b6313113f063979c8f334348baf25" />

    <h2 className="memtitle"><span className="permalink"><a href="#a666b6313113f063979c8f334348baf25">◆ </a></span>PAGING\_TABLE\_TTL</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.PAGING\_TABLE\_TTL = "paging\_table\_ttl"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. </p>
        <p>-1 indicates no timeout. Setting this option will cause a paging table to be generated when needed. The <a className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlResponse#a1f8d5ccaf2eb44e38c3ab55a6f7548ff">paging\_table</a> and other tables in the <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlResponse_1_1Info#ada58c67efefe44d1180e8d0305fe27e5">RESULT\_TABLE\_LIST</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.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L220">220</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="af30527b820c209626c9ba5e0d553f310" />

    <h2 className="memtitle"><span className="permalink"><a href="#af30527b820c209626c9ba5e0d553f310">◆ </a></span>PARALLEL\_EXECUTION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.PARALLEL\_EXECUTION = "parallel\_execution"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L238">238</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a329c23df45b60aa81047a0739f8299db" />

    <h2 className="memtitle"><span className="permalink"><a href="#a329c23df45b60aa81047a0739f8299db">◆ </a></span>PLAN\_CACHE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.PLAN\_CACHE = "plan\_cache"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L256">256</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a0fc4cba9894b18b482e7bb689b8305a1" />

    <h2 className="memtitle"><span className="permalink"><a href="#a0fc4cba9894b18b482e7bb689b8305a1">◆ </a></span>PREPARE\_MODE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.PREPARE\_MODE = "prepare\_mode"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L277">277</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a185f8f6e6422a5ddb8abf2c7155645db" />

    <h2 className="memtitle"><span className="permalink"><a href="#a185f8f6e6422a5ddb8abf2c7155645db">◆ </a></span>PRESERVE\_DICT\_ENCODING</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.PRESERVE\_DICT\_ENCODING = "preserve\_dict\_encoding"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L295">295</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a94cb8ee369be7eb92c19269dbf525ff9" />

    <h2 className="memtitle"><span className="permalink"><a href="#a94cb8ee369be7eb92c19269dbf525ff9">◆ </a></span>QUERY\_PARAMETERS</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.QUERY\_PARAMETERS = "query\_parameters"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Query parameters in JSON array or arrays (for inserting multiple rows). </p>
        <p>This can be used instead of <a className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlRequest#a6333c133550e2e2c33fbb380b7b46c14" title="An array of binary-encoded data for the records to be binded to the SQL query.">ExecuteSqlRequest.data</a> and <a className="el" href="/content/api/cs/classkinetica_1_1ExecuteSqlRequest#a7fb814af61a95b23f190b2c425d2109b" title="Avro schema of ExecuteSqlRequest.data.">ExecuteSqlRequest.request\_schema\_str</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L302">302</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="ad290c2ba361293581332eece4b5bb386" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad290c2ba361293581332eece4b5bb386">◆ </a></span>RESULTS\_CACHING</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.RESULTS\_CACHING = "results\_caching"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L320">320</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a45349680a4f82bac547ca5c6749b77f8" />

    <h2 className="memtitle"><span className="permalink"><a href="#a45349680a4f82bac547ca5c6749b77f8">◆ </a></span>RULE\_BASED\_OPTIMIZATION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.RULE\_BASED\_OPTIMIZATION = "rule\_based\_optimization"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L338">338</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a4150c15308c08d03bd826246f3c5b9cc" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4150c15308c08d03bd826246f3c5b9cc">◆ </a></span>SSQ\_OPTIMIZATION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.SSQ\_OPTIMIZATION = "ssq\_optimization"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L356">356</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a95e0cc60832e386efb127176cb869cc9" />

    <h2 className="memtitle"><span className="permalink"><a href="#a95e0cc60832e386efb127176cb869cc9">◆ </a></span>TRUE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.TRUE = "true"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1ExecuteSqlRequest_1_1Options" title="A set of string constants for the parameter ExecuteSqlRequest.options.">ExecuteSqlRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L81">81</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="a347997e72b5b9128f73d60d51ec2ad98" />

    <h2 className="memtitle"><span className="permalink"><a href="#a347997e72b5b9128f73d60d51ec2ad98">◆ </a></span>TTL</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.TTL = "ttl"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L361">361</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="ad7dca9b112ec6c85faba9016360a7631" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad7dca9b112ec6c85faba9016360a7631">◆ </a></span>UPDATE\_ON\_EXISTING\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.UPDATE\_ON\_EXISTING\_PK = "update\_on\_existing\_pk"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>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>. </p>
        <p>If set to <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</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 className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>, any such primary key collision will result in the insert/update being rejected and the error handled as determined by <a className="el" href="#ab7b119e64f59f2eee87c03549533cb4b">IGNORE\_EXISTING\_PK</a>. If the specified table does not have a primary key, then this option has no effect. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</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 className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>: Reject the insert or update when it results in a primary key collision with an existing record. </li>
        </ul>

        <p>The default value is <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L398">398</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <div id="abeb5dac19c9b1bb8fb0b0f870baab540" />

    <h2 className="memtitle"><span className="permalink"><a href="#abeb5dac19c9b1bb8fb0b0f870baab540">◆ </a></span>VALIDATE\_CHANGE\_COLUMN</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.ExecuteSqlRequest.Options.VALIDATE\_CHANGE\_COLUMN = "validate\_change\_column"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a> </li>
          <li> <a className="el" href="#a3044a4a1e8a617231f065a6d09cdb2c6">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a95e0cc60832e386efb127176cb869cc9">TRUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs#L421">421</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following file:

    <ul>
      <li>Kinetica/Protocol/<a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/ExecuteSql.cs">ExecuteSql.cs</a></li>
    </ul>
  </div>
</div>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.