"cause": "not_group_by_or_distinct" }, "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "report_product_sales_data_unique", "ranges": [ "000030 <= hq_code <= 000030 AND 2018-05-11 < report_date" ], "index_dives_for_eq_ranges": true, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 1848962, "cost": 2.22e6, "chosen": true }, { "index": "report_product_sales_data_hq_code_orgz_id_index", "ranges": [ "000030 <= hq_code <= 000030 AND 229 <= orgz_id <= 229 AND 2018-05-11 < report_date" ], "index_dives_for_eq_ranges": true, "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 37088, "cost": 44507, "chosen": true } ], &nbs |