Description
For predicate: any i in uarr_i SATISFIES i > 34741 END and norm_i <= 60335
For index key: DISTINCT ARRAY `i` FOR i in `uarr_i` END
(distinct (array _usv_1 for _usv_1 in uarr_i end) is used to generate histogram.
But in selectivity calculation (distinct (`uarr_i`)) is used to look up for histogram, and histogram returns nil.
update statistics for ks1(DISTINCT ARRAY `i` FOR i in `uarr_i` END) and
update statistics for ks(DISTINCT uarr_i)
may need to identify each other and switch when necessary.
Attachments
Issue Links
- relates to
-
MB-38455 Index advisor to advise for cost-based optimizer
- Closed
For Gerrit Dashboard: MB-40548 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
137982,2 | MB-40548 Transform simple array construct for histogram key and predicate matching | master | query | Status: MERGED | +2 | +1 |
137983,2 | MB-40548 Transform simple array construct for histogram key and predicate matching | master | query-ee | Status: MERGED | +2 | +1 |
138241,3 | MB-40548 Prefer index with no array key | master | query | Status: MERGED | +2 | +1 |