Explain Query (mysql)
EXPLAIN SELECT COUNT(DISTINCT product_id) FROM `product_stats` WHERE date BETWEEN SUBDATE(CURDATE(), INTERVAL 14 DAY) AND CURDATE() AND qty_sold > 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | product_stats | range | product_stats_ibfk_1, idx_date, product_stats_date_category, qty_sold | product_stats_date_category | 4 | 69128 | 31.54 | Using index condition; Using where; Using MRR |