1
0
Fork 0
arangodb/Documentation/Examples/dropIndex.generated

63 lines
3.7 KiB
Plaintext

arangosh&gt; db.example.ensureIndex({ <span class="hljs-attr">type</span>: <span class="hljs-string">"skiplist"</span>, <span class="hljs-attr">fields</span>: [ <span class="hljs-string">"a"</span>, <span class="hljs-string">"b"</span> ] });
{
<span class="hljs-string">"deduplicate"</span> : <span class="hljs-literal">true</span>,
<span class="hljs-string">"fields"</span> : [
<span class="hljs-string">"a"</span>,
<span class="hljs-string">"b"</span>
],
<span class="hljs-string">"id"</span> : <span class="hljs-string">"example/74433"</span>,
<span class="hljs-string">"isNewlyCreated"</span> : <span class="hljs-literal">true</span>,
<span class="hljs-string">"name"</span> : <span class="hljs-string">"idx_1646382081922564096"</span>,
<span class="hljs-string">"selectivityEstimate"</span> : <span class="hljs-number">1</span>,
<span class="hljs-string">"sparse"</span> : <span class="hljs-literal">false</span>,
<span class="hljs-string">"type"</span> : <span class="hljs-string">"skiplist"</span>,
<span class="hljs-string">"unique"</span> : <span class="hljs-literal">false</span>,
<span class="hljs-string">"code"</span> : <span class="hljs-number">201</span>
}
arangosh&gt; <span class="hljs-keyword">var</span> indexInfo = db.example.getIndexes();
arangosh&gt; indexInfo;
[
{
<span class="hljs-string">"fields"</span> : [
<span class="hljs-string">"_key"</span>
],
<span class="hljs-string">"id"</span> : <span class="hljs-string">"example/0"</span>,
<span class="hljs-string">"name"</span> : <span class="hljs-string">"primary"</span>,
<span class="hljs-string">"selectivityEstimate"</span> : <span class="hljs-number">1</span>,
<span class="hljs-string">"sparse"</span> : <span class="hljs-literal">false</span>,
<span class="hljs-string">"type"</span> : <span class="hljs-string">"primary"</span>,
<span class="hljs-string">"unique"</span> : <span class="hljs-literal">true</span>
},
{
<span class="hljs-string">"deduplicate"</span> : <span class="hljs-literal">true</span>,
<span class="hljs-string">"fields"</span> : [
<span class="hljs-string">"a"</span>,
<span class="hljs-string">"b"</span>
],
<span class="hljs-string">"id"</span> : <span class="hljs-string">"example/74433"</span>,
<span class="hljs-string">"name"</span> : <span class="hljs-string">"idx_1646382081922564096"</span>,
<span class="hljs-string">"selectivityEstimate"</span> : <span class="hljs-number">1</span>,
<span class="hljs-string">"sparse"</span> : <span class="hljs-literal">false</span>,
<span class="hljs-string">"type"</span> : <span class="hljs-string">"skiplist"</span>,
<span class="hljs-string">"unique"</span> : <span class="hljs-literal">false</span>
}
]
arangosh&gt; db._dropIndex(indexInfo[<span class="hljs-number">0</span>])
<span class="hljs-literal">false</span>
arangosh&gt; db._dropIndex(indexInfo[<span class="hljs-number">1</span>].id)
<span class="hljs-literal">true</span>
arangosh&gt; indexInfo = db.example.getIndexes();
[
{
<span class="hljs-string">"fields"</span> : [
<span class="hljs-string">"_key"</span>
],
<span class="hljs-string">"id"</span> : <span class="hljs-string">"example/0"</span>,
<span class="hljs-string">"name"</span> : <span class="hljs-string">"primary"</span>,
<span class="hljs-string">"selectivityEstimate"</span> : <span class="hljs-number">1</span>,
<span class="hljs-string">"sparse"</span> : <span class="hljs-literal">false</span>,
<span class="hljs-string">"type"</span> : <span class="hljs-string">"primary"</span>,
<span class="hljs-string">"unique"</span> : <span class="hljs-literal">true</span>
}
]