arangosh> var explain = require("@arangodb/aql/explainer").explain;
arangosh> db.example.ensureIndex({ type: "skiplist", fields: [ "a", "b" ] });
{
"deduplicate" : true,
"fields" : [
"a",
"b"
],
"id" : "example/68965",
"isNewlyCreated" : true,
"name" : "idx_1646382033809702914",
"selectivityEstimate" : 1,
"sparse" : false,
"type" : "skiplist",
"unique" : false,
"code" : 201
}
arangosh> explain("FOR doc IN example FILTER doc.a < 23 RETURN doc", {colors:false});
Query String (47 chars, cacheable: true):
FOR doc IN example FILTER doc.a < 23 RETURN doc
Execution plan:
Id NodeType Est. Comment
1 SingletonNode 1 * ROOT
6 IndexNode 0 - FOR doc IN example
5 ReturnNode 0 - RETURN doc
Indexes used:
By Name Type Collection Unique Sparse Selectivity Fields Ranges
6 idx_1646382033809702914 skiplist example false false 100.00 % [ `a`, `b` ] (doc.`a` < 23)
Optimization rules applied:
Id RuleName
1 use-indexes
2 remove-filter-covered-by-index
3 remove-unnecessary-calculations-2