> ## 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#afdff9efc553cf8dc15f16c1f21029e97" title="Optional parameters.">CreateJoinTableRequest.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:abb438de594c6a6f05adf503917426e9a" id="r_abb438de594c6a6f05adf503917426e9a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#abb438de594c6a6f05adf503917426e9a">CREATE\_TEMP\_TABLE</a> = "create\_temp\_table"</td>
      </tr>

      <tr className="memdesc:abb438de594c6a6f05adf503917426e9a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a32082d143550f6c3106d5e47834788a7">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#af60ca7898472d3f8e62f189495181938" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a>. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a32082d143550f6c3106d5e47834788a7">
        <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:a32082d143550f6c3106d5e47834788a7">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:ab25ba5a114c0930218fec8655e7b8492">
        <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:ab25ba5a114c0930218fec8655e7b8492">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a8801ec82f8dc7634f6ebdb66c47bae92">
        <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#af60ca7898472d3f8e62f189495181938" 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/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema for the join. <br /></td>
      </tr>

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

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

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

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

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

      <tr className="memdesc:a976af01aaba323b01390f13b7ca7f068">
        <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:a976af01aaba323b01390f13b7ca7f068">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a9c235d84751d62a597897d4e0c74b904">
        <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#af60ca7898472d3f8e62f189495181938" title="Name of the join table to be created, in [schema_name.">CreateJoinTableRequest.join\_table\_name</a>. <br /></td>
      </tr>

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

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

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

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

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

      <tr className="memdesc:a91d2498d4bb20dc6a37d1983bf8be6a5">
        <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/showtable#af70f60085dc4c30ab3ffd15ff4622837">Kinetica.showTable</a>; optimization needed for large overlapped equi-join stencils. <br /></td>
      </tr>

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

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

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

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

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

      <tr className="memdesc:ad0e555f28a442238941da41d7dfa13ac">
        <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:ad0e555f28a442238941da41d7dfa13ac">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:ad609a3c163d225ec94faf375d4bd5421">
        <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:ad609a3c163d225ec94faf375d4bd5421">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a3a5dcc90a590c0447acb369d49cf31a6">
        <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:a3a5dcc90a590c0447acb369d49cf31a6">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:a061fbac63825d91abd9b1f41295b073b">
        <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:a061fbac63825d91abd9b1f41295b073b">
        <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_1CreateJoinTableRequest#afdff9efc553cf8dc15f16c1f21029e97" title="Optional parameters.">CreateJoinTableRequest.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/CreateJoinTable.cs#L24">24</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
    </div>

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

    <div id="a61dd9c92f15b7a97883985b858e7ba4f" />

    <h2 className="memtitle"><span className="permalink"><a href="#a61dd9c92f15b7a97883985b858e7ba4f">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L100">100</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a8801ec82f8dc7634f6ebdb66c47bae92" />

    <h2 className="memtitle"><span className="permalink"><a href="#a8801ec82f8dc7634f6ebdb66c47bae92">◆ </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#af60ca7898472d3f8e62f189495181938" 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/createschema#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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L69">69</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="abb438de594c6a6f05adf503917426e9a" />

    <h2 className="memtitle"><span className="permalink"><a href="#abb438de594c6a6f05adf503917426e9a">◆ </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="#a32082d143550f6c3106d5e47834788a7">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#af60ca7898472d3f8e62f189495181938" 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#a78bb8efa65faee97e225f8031f977d34">QUALIFIED\_JOIN\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a32082d143550f6c3106d5e47834788a7">TRUE</a> </li>
          <li> <a className="el" href="#ab25ba5a114c0930218fec8655e7b8492">FALSE</a> </li>
        </ul>

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

    <div id="ad609a3c163d225ec94faf375d4bd5421" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad609a3c163d225ec94faf375d4bd5421">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L127">127</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a061fbac63825d91abd9b1f41295b073b" />

    <h2 className="memtitle"><span className="permalink"><a href="#a061fbac63825d91abd9b1f41295b073b">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L138">138</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a3a5dcc90a590c0447acb369d49cf31a6" />

    <h2 className="memtitle"><span className="permalink"><a href="#a3a5dcc90a590c0447acb369d49cf31a6">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L134">134</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="af44f6b6852741978a1edf30b79e3c9a5" />

    <h2 className="memtitle"><span className="permalink"><a href="#af44f6b6852741978a1edf30b79e3c9a5">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L120">120</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="ad0e555f28a442238941da41d7dfa13ac" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad0e555f28a442238941da41d7dfa13ac">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L105">105</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="ab25ba5a114c0930218fec8655e7b8492" />

    <h2 className="memtitle"><span className="permalink"><a href="#ab25ba5a114c0930218fec8655e7b8492">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L59">59</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a7913bc1844b82af6757dea6f28b5336a" />

    <h2 className="memtitle"><span className="permalink"><a href="#a7913bc1844b82af6757dea6f28b5336a">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L72">72</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a00d1b46d70ede79bfc10c68e0f9f65b8" />

    <h2 className="memtitle"><span className="permalink"><a href="#a00d1b46d70ede79bfc10c68e0f9f65b8">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L110">110</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a333e01e7938d90c66c34b2b24a38450b" />

    <h2 className="memtitle"><span className="permalink"><a href="#a333e01e7938d90c66c34b2b24a38450b">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L115">115</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a91d2498d4bb20dc6a37d1983bf8be6a5" />

    <h2 className="memtitle"><span className="permalink"><a href="#a91d2498d4bb20dc6a37d1983bf8be6a5">◆ </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/showtable#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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L94">94</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a976af01aaba323b01390f13b7ca7f068" />

    <h2 className="memtitle"><span className="permalink"><a href="#a976af01aaba323b01390f13b7ca7f068">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L77">77</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a32082d143550f6c3106d5e47834788a7" />

    <h2 className="memtitle"><span className="permalink"><a href="#a32082d143550f6c3106d5e47834788a7">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L55">55</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a9c235d84751d62a597897d4e0c74b904" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9c235d84751d62a597897d4e0c74b904">◆ </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#af60ca7898472d3f8e62f189495181938" 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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L82">82</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.cs</a>.</p>
      </div>
    </div>

    <div id="a69232c201f9c8800930ffcd2842b18ba" />

    <h2 className="memtitle"><span className="permalink"><a href="#a69232c201f9c8800930ffcd2842b18ba">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs#L86">86</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateJoinTable.cs">CreateJoinTable.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/CreateJoinTable.cs">CreateJoinTable.cs</a></li>
    </ul>
  </div>
</div>


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