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

> kinetica.CreateJoinTableRequest.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_1CreateJoinTableRequest#a8101633fca6c7d501d2606ed79b89133" title="Optional parameters.">CreateJoinTableRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Static Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:a0e9dc9bcce97ac75eb93fda6f0b1b661" id="r_a0e9dc9bcce97ac75eb93fda6f0b1b661">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a0e9dc9bcce97ac75eb93fda6f0b1b661">CREATE\_TEMP\_TABLE</a> = "create\_temp\_table"</td>
      </tr>

      <tr className="memdesc:a0e9dc9bcce97ac75eb93fda6f0b1b661">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#aacbbb5f5ec746a1d91c5afcd076c8b0e">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="/content/api/cs/classkinetica_1_1CreateJoinTableRequest#acba272547a6c6e84565ccff0d00bb181" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a>. <br /></td>
      </tr>

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

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

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

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

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

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

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

      <tr className="memitem:afe5a41fbb4a78459fdeb0f903b5529e5" id="r_afe5a41fbb4a78459fdeb0f903b5529e5">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#afe5a41fbb4a78459fdeb0f903b5529e5">COLLECTION\_NAME</a> = "collection\_name"</td>
      </tr>

      <tr className="memdesc:afe5a41fbb4a78459fdeb0f903b5529e5">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–please specify the containing schema for the join as part of <a className="el" href="/content/api/cs/classkinetica_1_1CreateJoinTableRequest#acba272547a6c6e84565ccff0d00bb181" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema for the join. <br /></td>
      </tr>

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

      <tr className="memitem:ae5c0226596690ddb4bfc56fef88cda8b" id="r_ae5c0226596690ddb4bfc56fef88cda8b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae5c0226596690ddb4bfc56fef88cda8b">MAX\_QUERY\_DIMENSIONS</a> = "max\_query\_dimensions"</td>
      </tr>

      <tr className="memdesc:ae5c0226596690ddb4bfc56fef88cda8b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">No longer used. <br /></td>
      </tr>

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

      <tr className="memitem:af897e4ee51e95ed4eebceb67af5bf97e" id="r_af897e4ee51e95ed4eebceb67af5bf97e">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af897e4ee51e95ed4eebceb67af5bf97e">STRATEGY\_DEFINITION</a> = "strategy\_definition"</td>
      </tr>

      <tr className="memdesc:af897e4ee51e95ed4eebceb67af5bf97e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The <a href="/content/rm/concepts/#tier-strategies" target="_top">tier strategy</a> for the table and its columns. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a26ccedc7ece4b038f5fdd1c47ad29fbe">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the join table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateJoinTableRequest#acba272547a6c6e84565ccff0d00bb181" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a>. <br /></td>
      </tr>

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

      <tr className="memitem:a6bb0e077852d2c98ab1d5abadf9cb914" id="r_a6bb0e077852d2c98ab1d5abadf9cb914">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a6bb0e077852d2c98ab1d5abadf9cb914">VIEW\_ID</a> = "view\_id"</td>
      </tr>

      <tr className="memdesc:a6bb0e077852d2c98ab1d5abadf9cb914">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">View this projection is part of. <br /></td>
      </tr>

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

      <tr className="memitem:ae84a99ee445ab9cfe8404c51616d20e6" id="r_ae84a99ee445ab9cfe8404c51616d20e6">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae84a99ee445ab9cfe8404c51616d20e6">NO\_COUNT</a> = "no\_count"</td>
      </tr>

      <tr className="memdesc:ae84a99ee445ab9cfe8404c51616d20e6">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Return a count of 0 for the join table for logging and for <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#af70f60085dc4c30ab3ffd15ff4622837">Kinetica.showTable</a>; optimization needed for large overlapped equi-join stencils. <br /></td>
      </tr>

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

      <tr className="memitem:a363266fb33e69c978e0fa9351eef0089" id="r_a363266fb33e69c978e0fa9351eef0089">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a363266fb33e69c978e0fa9351eef0089">CHUNK\_SIZE</a> = "chunk\_size"</td>
      </tr>

      <tr className="memdesc:a363266fb33e69c978e0fa9351eef0089">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Maximum number of records per joined-chunk for this table. <br /></td>
      </tr>

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

      <tr className="memitem:a55305d255dcd4579bbb03f4d5ac2f656" id="r_a55305d255dcd4579bbb03f4d5ac2f656">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a55305d255dcd4579bbb03f4d5ac2f656">ENABLE\_VIRTUAL\_CHUNKING</a> = "enable\_virtual\_chunking"</td>
      </tr>

      <tr className="memdesc:a55305d255dcd4579bbb03f4d5ac2f656">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Collect chunks with accumulated size less than chunk\_size into a single chunk. <br /></td>
      </tr>

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

      <tr className="memitem:a40d881cd0624f29613b687280ac5086b" id="r_a40d881cd0624f29613b687280ac5086b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a40d881cd0624f29613b687280ac5086b">MAX\_VIRTUAL\_CHUNK\_SIZE</a> = "max\_virtual\_chunk\_size"</td>
      </tr>

      <tr className="memdesc:a40d881cd0624f29613b687280ac5086b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Maximum number of records per virtual-chunk. <br /></td>
      </tr>

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

      <tr className="memitem:aafc1e97a7f544e2b0185f7854221d580" id="r_aafc1e97a7f544e2b0185f7854221d580">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aafc1e97a7f544e2b0185f7854221d580">MIN\_VIRTUAL\_CHUNK\_SIZE</a> = "min\_virtual\_chunk\_size"</td>
      </tr>

      <tr className="memdesc:aafc1e97a7f544e2b0185f7854221d580">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Minimum number of records per virtual-chunk. <br /></td>
      </tr>

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

      <tr className="memitem:a187fc94710fe2e9546e199dd9841cc85" id="r_a187fc94710fe2e9546e199dd9841cc85">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a187fc94710fe2e9546e199dd9841cc85">ENABLE\_SPARSE\_VIRTUAL\_CHUNKING</a> = "enable\_sparse\_virtual\_chunking"</td>
      </tr>

      <tr className="memdesc:a187fc94710fe2e9546e199dd9841cc85">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Materialize virtual chunks with only non-deleted values. <br /></td>
      </tr>

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

      <tr className="memitem:a407d1963c613ec6c45fcf668a4ff6eea" id="r_a407d1963c613ec6c45fcf668a4ff6eea">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a407d1963c613ec6c45fcf668a4ff6eea">ENABLE\_EQUI\_JOIN\_LAZY\_RESULT\_STORE</a> = "enable\_equi\_join\_lazy\_result\_store"</td>
      </tr>

      <tr className="memdesc:a407d1963c613ec6c45fcf668a4ff6eea">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Allow using the lazy result store to cache computation of one side of a multichunk equi-join. <br /></td>
      </tr>

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

      <tr className="memitem:a1c32e2b8f5221d0c130bcf268ed10a6f" id="r_a1c32e2b8f5221d0c130bcf268ed10a6f">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a1c32e2b8f5221d0c130bcf268ed10a6f">ENABLE\_PREDICATE\_EQUI\_JOIN\_LAZY\_RESULT\_STORE</a> = "enable\_predicate\_equi\_join\_lazy\_result\_store"</td>
      </tr>

      <tr className="memdesc:a1c32e2b8f5221d0c130bcf268ed10a6f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-join. <br /></td>
      </tr>

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

      <tr className="memitem:ab85ba264ffc10516d0e58f2a576d617a" id="r_ab85ba264ffc10516d0e58f2a576d617a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ab85ba264ffc10516d0e58f2a576d617a">ENABLE\_PK\_EQUI\_JOIN</a> = "enable\_pk\_equi\_join"</td>
      </tr>

      <tr className="memdesc:ab85ba264ffc10516d0e58f2a576d617a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use equi-join to do primary key joins rather than using primary key index. <br /></td>
      </tr>

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

    <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_1CreateJoinTableRequest#a8101633fca6c7d501d2606ed79b89133" title="Optional parameters.">CreateJoinTableRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00024">24</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a363266fb33e69c978e0fa9351eef0089">◆ </a></span>CHUNK\_SIZE</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.CreateJoinTableRequest.Options.CHUNK\_SIZE = "chunk\_size"</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>Maximum number of records per joined-chunk for this table. </p>
        <p>Defaults to the gpudb.conf file chunk size.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00100">100</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#afe5a41fbb4a78459fdeb0f903b5529e5">◆ </a></span>COLLECTION\_NAME</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.CreateJoinTableRequest.Options.COLLECTION\_NAME = "collection\_name"</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>\[DEPRECATED–please specify the containing schema for the join as part of <a className="el" href="/content/api/cs/classkinetica_1_1CreateJoinTableRequest#acba272547a6c6e84565ccff0d00bb181" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema for the join. </p>
        <p>If the schema is non-existent, it will be automatically created. The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00069">69</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a0e9dc9bcce97ac75eb93fda6f0b1b661">◆ </a></span>CREATE\_TEMP\_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.CreateJoinTableRequest.Options.CREATE\_TEMP\_TABLE = "create\_temp\_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>If <a className="el" href="#aacbbb5f5ec746a1d91c5afcd076c8b0e">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="/content/api/cs/classkinetica_1_1CreateJoinTableRequest#acba272547a6c6e84565ccff0d00bb181" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a>. </p>
        <p>This is always allowed even if the caller does not have permission to create tables. The generated name is returned in <a className="el" href="/content/api/cs/structkinetica_1_1CreateJoinTableResponse_1_1Info#a9c879b9a5274abc311e2d4680bda5a80">QUALIFIED\_JOIN\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#aacbbb5f5ec746a1d91c5afcd076c8b0e">TRUE</a> </li>
          <li> <a className="el" href="#a81b1d75812cd0d82e5dc83b4948507e9">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a81b1d75812cd0d82e5dc83b4948507e9">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00051">51</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a407d1963c613ec6c45fcf668a4ff6eea">◆ </a></span>ENABLE\_EQUI\_JOIN\_LAZY\_RESULT\_STORE</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.CreateJoinTableRequest.Options.ENABLE\_EQUI\_JOIN\_LAZY\_RESULT\_STORE = "enable\_equi\_join\_lazy\_result\_store"</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>Allow using the lazy result store to cache computation of one side of a multichunk equi-join. </p>
        <p>Reduces computation but also reduces parallelism to the number of chunks on the other side of the equi-join.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00127">127</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ab85ba264ffc10516d0e58f2a576d617a">◆ </a></span>ENABLE\_PK\_EQUI\_JOIN</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.CreateJoinTableRequest.Options.ENABLE\_PK\_EQUI\_JOIN = "enable\_pk\_equi\_join"</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 equi-join to do primary key joins rather than using primary key index. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00138">138</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a1c32e2b8f5221d0c130bcf268ed10a6f">◆ </a></span>ENABLE\_PREDICATE\_EQUI\_JOIN\_LAZY\_RESULT\_STORE</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.CreateJoinTableRequest.Options.ENABLE\_PREDICATE\_EQUI\_JOIN\_LAZY\_RESULT\_STORE = "enable\_predicate\_equi\_join\_lazy\_result\_store"</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>Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-join. </p>
        <p>Reduces computation but also reduces parallelism to the number of chunks on the other side of the equi-join.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00134">134</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a187fc94710fe2e9546e199dd9841cc85">◆ </a></span>ENABLE\_SPARSE\_VIRTUAL\_CHUNKING</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.CreateJoinTableRequest.Options.ENABLE\_SPARSE\_VIRTUAL\_CHUNKING = "enable\_sparse\_virtual\_chunking"</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>Materialize virtual chunks with only non-deleted values. </p>
        <p>The default value is 'false'.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00120">120</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a55305d255dcd4579bbb03f4d5ac2f656">◆ </a></span>ENABLE\_VIRTUAL\_CHUNKING</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.CreateJoinTableRequest.Options.ENABLE\_VIRTUAL\_CHUNKING = "enable\_virtual\_chunking"</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>Collect chunks with accumulated size less than chunk\_size into a single chunk. </p>
        <p>The default value is 'false'.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00105">105</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a81b1d75812cd0d82e5dc83b4948507e9">◆ </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.CreateJoinTableRequest.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_1CreateJoinTableRequest_1_1Options" title="A set of string constants for the parameter CreateJoinTableRequest.options.">CreateJoinTableRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00059">59</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae5c0226596690ddb4bfc56fef88cda8b">◆ </a></span>MAX\_QUERY\_DIMENSIONS</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.CreateJoinTableRequest.Options.MAX\_QUERY\_DIMENSIONS = "max\_query\_dimensions"</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>No longer used. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00072">72</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a40d881cd0624f29613b687280ac5086b">◆ </a></span>MAX\_VIRTUAL\_CHUNK\_SIZE</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.CreateJoinTableRequest.Options.MAX\_VIRTUAL\_CHUNK\_SIZE = "max\_virtual\_chunk\_size"</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>Maximum number of records per virtual-chunk. </p>
        <p>When set, enables virtual chunking. Defaults to chunk\_size if virtual chunking otherwise enabled.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00110">110</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aafc1e97a7f544e2b0185f7854221d580">◆ </a></span>MIN\_VIRTUAL\_CHUNK\_SIZE</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.CreateJoinTableRequest.Options.MIN\_VIRTUAL\_CHUNK\_SIZE = "min\_virtual\_chunk\_size"</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>Minimum number of records per virtual-chunk. </p>
        <p>When set, enables virtual chunking. Defaults to chunk\_size if virtual chunking otherwise enabled.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00115">115</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae84a99ee445ab9cfe8404c51616d20e6">◆ </a></span>NO\_COUNT</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.CreateJoinTableRequest.Options.NO\_COUNT = "no\_count"</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>Return a count of 0 for the join table for logging and for <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#af70f60085dc4c30ab3ffd15ff4622837">Kinetica.showTable</a>; optimization needed for large overlapped equi-join stencils. </p>
        <p>The default value is 'false'.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00094">94</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af897e4ee51e95ed4eebceb67af5bf97e">◆ </a></span>STRATEGY\_DEFINITION</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.CreateJoinTableRequest.Options.STRATEGY\_DEFINITION = "strategy\_definition"</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>The <a href="/content/rm/concepts/#tier-strategies" target="_top">tier strategy</a> for the table and its columns. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00077">77</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aacbbb5f5ec746a1d91c5afcd076c8b0e">◆ </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.CreateJoinTableRequest.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_1CreateJoinTableRequest_1_1Options" title="A set of string constants for the parameter CreateJoinTableRequest.options.">CreateJoinTableRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00055">55</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a26ccedc7ece4b038f5fdd1c47ad29fbe">◆ </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.CreateJoinTableRequest.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 join table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateJoinTableRequest#acba272547a6c6e84565ccff0d00bb181" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00082">82</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a6bb0e077852d2c98ab1d5abadf9cb914">◆ </a></span>VIEW\_ID</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.CreateJoinTableRequest.Options.VIEW\_ID = "view\_id"</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>View this projection is part of. </p>
        <p>The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source#l00086">86</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <hr />

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

    <ul>
      <li>\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/<a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2CreateJoinTable_8cs_source">CreateJoinTable.cs</a></li>
    </ul>
  </div>
</div>