Materialize/doc/user/layouts/partials/sql-grammar/create-index.svg

<svg xmlns="http://www.w3.org/2000/svg" width="1195" height="341">
   <polygon points="9 17 1 13 1 21"/>
   <polygon points="17 17 9 13 9 21"/>
   <rect x="31" y="3" width="76" height="32" rx="10"/>
   <rect x="29"
         y="1"
         width="76"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="39" y="21">CREATE</text>
   <rect x="45" y="113" width="62" height="32" rx="10"/>
   <rect x="43"
         y="111"
         width="62"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="53" y="131">INDEX</text>
   <rect x="127" y="113" width="98" height="32"/>
   <rect x="125" y="111" width="98" height="32" class="nonterminal"/>
   <text class="nonterminal" x="135" y="131">index_name</text>
   <rect x="265" y="145" width="34" height="32" rx="10"/>
   <rect x="263"
         y="143"
         width="34"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="273" y="163">IN</text>
   <rect x="319" y="145" width="84" height="32" rx="10"/>
   <rect x="317"
         y="143"
         width="84"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="327" y="163">CLUSTER</text>
   <rect x="423" y="145" width="108" height="32"/>
   <rect x="421" y="143" width="108" height="32" class="nonterminal"/>
   <text class="nonterminal" x="431" y="163">cluster_name</text>
   <rect x="571" y="113" width="40" height="32" rx="10"/>
   <rect x="569"
         y="111"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="579" y="131">ON</text>
   <rect x="631" y="113" width="82" height="32"/>
   <rect x="629" y="111" width="82" height="32" class="nonterminal"/>
   <text class="nonterminal" x="639" y="131">obj_name</text>
   <rect x="753" y="145" width="64" height="32" rx="10"/>
   <rect x="751"
         y="143"
         width="64"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="761" y="163">USING</text>
   <rect x="837" y="145" width="70" height="32"/>
   <rect x="835" y="143" width="70" height="32" class="nonterminal"/>
   <text class="nonterminal" x="845" y="163">method</text>
   <rect x="947" y="113" width="26" height="32" rx="10"/>
   <rect x="945"
         y="111"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="955" y="131">(</text>
   <rect x="1013" y="113" width="74" height="32"/>
   <rect x="1011" y="111" width="74" height="32" class="nonterminal"/>
   <text class="nonterminal" x="1021" y="131">col_expr</text>
   <rect x="1013" y="69" width="24" height="32" rx="10"/>
   <rect x="1011"
         y="67"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="1021" y="87">,</text>
   <rect x="1127" y="113" width="26" height="32" rx="10"/>
   <rect x="1125"
         y="111"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="1135" y="131">)</text>
   <rect x="45" y="189" width="132" height="32" rx="10"/>
   <rect x="43"
         y="187"
         width="132"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="53" y="207">DEFAULT INDEX</text>
   <rect x="217" y="221" width="34" height="32" rx="10"/>
   <rect x="215"
         y="219"
         width="34"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="225" y="239">IN</text>
   <rect x="271" y="221" width="84" height="32" rx="10"/>
   <rect x="269"
         y="219"
         width="84"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="279" y="239">CLUSTER</text>
   <rect x="375" y="221" width="108" height="32"/>
   <rect x="373" y="219" width="108" height="32" class="nonterminal"/>
   <text class="nonterminal" x="383" y="239">cluster_name</text>
   <rect x="523" y="189" width="40" height="32" rx="10"/>
   <rect x="521"
         y="187"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="531" y="207">ON</text>
   <rect x="583" y="189" width="82" height="32"/>
   <rect x="581" y="187" width="82" height="32" class="nonterminal"/>
   <text class="nonterminal" x="591" y="207">obj_name</text>
   <rect x="705" y="221" width="64" height="32" rx="10"/>
   <rect x="703"
         y="219"
         width="64"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="713" y="239">USING</text>
   <rect x="789" y="221" width="70" height="32"/>
   <rect x="787" y="219" width="70" height="32" class="nonterminal"/>
   <text class="nonterminal" x="797" y="239">method</text>
   <rect x="1045" y="307" width="102" height="32"/>
   <rect x="1043"
         y="305"
         width="102"
         height="32"
         class="nonterminal"/>
   <text class="nonterminal" x="1053" y="325">with_options</text>
   <path class="line"
         d="m17 17 h2 m0 0 h10 m76 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-126 110 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m62 0 h10 m0 0 h10 m98 0 h10 m20 0 h10 m0 0 h276 m-306 0 h20 m286 0 h20 m-326 0 q10 0 10 10 m306 0 q0 -10 10 -10 m-316 10 v12 m306 0 v-12 m-306 12 q0 10 10 10 m286 0 q10 0 10 -10 m-296 10 h10 m34 0 h10 m0 0 h10 m84 0 h10 m0 0 h10 m108 0 h10 m20 -32 h10 m40 0 h10 m0 0 h10 m82 0 h10 m20 0 h10 m0 0 h164 m-194 0 h20 m174 0 h20 m-214 0 q10 0 10 10 m194 0 q0 -10 10 -10 m-204 10 v12 m194 0 v-12 m-194 12 q0 10 10 10 m174 0 q10 0 10 -10 m-184 10 h10 m64 0 h10 m0 0 h10 m70 0 h10 m20 -32 h10 m26 0 h10 m20 0 h10 m74 0 h10 m-114 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m94 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-94 0 h10 m24 0 h10 m0 0 h50 m20 44 h10 m26 0 h10 m-1148 0 h20 m1128 0 h20 m-1168 0 q10 0 10 10 m1148 0 q0 -10 10 -10 m-1158 10 v56 m1148 0 v-56 m-1148 56 q0 10 10 10 m1128 0 q10 0 10 -10 m-1138 10 h10 m132 0 h10 m20 0 h10 m0 0 h276 m-306 0 h20 m286 0 h20 m-326 0 q10 0 10 10 m306 0 q0 -10 10 -10 m-316 10 v12 m306 0 v-12 m-306 12 q0 10 10 10 m286 0 q10 0 10 -10 m-296 10 h10 m34 0 h10 m0 0 h10 m84 0 h10 m0 0 h10 m108 0 h10 m20 -32 h10 m40 0 h10 m0 0 h10 m82 0 h10 m20 0 h10 m0 0 h164 m-194 0 h20 m174 0 h20 m-214 0 q10 0 10 10 m194 0 q0 -10 10 -10 m-204 10 v12 m194 0 v-12 m-194 12 q0 10 10 10 m174 0 q10 0 10 -10 m-184 10 h10 m64 0 h10 m0 0 h10 m70 0 h10 m20 -32 h274 m22 -76 l2 0 m2 0 l2 0 m2 0 l2 0 m-192 162 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h112 m-142 0 h20 m122 0 h20 m-162 0 q10 0 10 10 m142 0 q0 -10 10 -10 m-152 10 v12 m142 0 v-12 m-142 12 q0 10 10 10 m122 0 q10 0 10 -10 m-132 10 h10 m102 0 h10 m23 -32 h-3"/>
   <polygon points="1185 289 1193 285 1193 293"/>
   <polygon points="1185 289 1177 285 1177 293"/>
</svg>