Explain Query (mysql)
EXPLAIN SELECT
Calendar_Date d
FROM
Dim_Date
WHERE
Calendar_Date BETWEEN SUBDATE('2025-04-11', INTERVAL 2 DAY) AND DATE_ADD('2025-04-11', INTERVAL 6 DAY)
GROUP BY
Calendar_Date
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Dim_Date | range | PRIMARY | PRIMARY | 3 | 9 | 100.00 | Using where; Using index |