Running ArangoDB 3.4.5 on a collection with 100.000 items.
Each item has singe-valued field _type and there are about 20 different
values for this field.
The field is indexed by a hash index: https://nimb.ws/yh4rRb
This query performs a full table scan instead of using the index.
Am I missing something here?
For doc in import
return distinct doc._type
Query String:
For doc in import
return distinct doc._type
Execution plan:
Id NodeType Est. Comment
1 SingletonNode 1 * ROOT
2 EnumerateCollectionNode 95238 - FOR doc IN import /* full
collection scan, projections: `_type` */
3 CalculationNode 95238 - LET #1 = doc.`_type` /*
attribute expression */ /* collections used: doc : import */
4 CollectNode 76190 - COLLECT #3 = #1 /* distinct
*/
5 ReturnNode 76190 - RETURN #3
Indexes used:
none
Optimization rules applied:
Id RuleName
1 reduce-extraction-to-projection
--
You received this message because you are subscribed to the Google Groups
"ArangoDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/arangodb/99d65a1f-0990-4b4a-ba29-c86b6dc0690b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
