33 NDV strings Id: 6066: [ { "$match" : { "mixed_arr_str_70_30" : { "$gt" : "LeG7", "$lt" : "LgG7" } } } ], qtype: medium range, data type: array cardinality: 126, Histogram estimation: 394.17, errors: { "absError" : 268.17, "relError" : 2.13, "selError" : 26.82 } Scalar - > 0 BucketId: 9, LeG7, { "boundaryCount" : 18, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 206, BucketId: 10, MQyE, { "boundaryCount" : 13, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 219 Unique BucketId: 25, IIIZ, { "boundaryCount" : 33, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 703, BucketId: 26, xxxx, { "boundaryCount" : 26, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 729, Min BucketId: 25, IIIZ, { "boundaryCount" : 7, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 291, BucketId: 26, yyy0, { "boundaryCount" : 3, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 294, Max BucketId: 22, IIIZ, { "boundaryCount" : 20, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 165, "cumulativeDistincts" : 23 } BucketId: 23, xxxx, { "boundaryCount" : 15, "rangeCount" : 0, "rangeDistincts" : 0, "cumulativeCount" : 180, "cumulativeDistincts" : 24 } Range query on array Card(ArrayMin(a < valHigh)) - Card(ArrayMax(a < valLow)) = 291 - 165 = 136