Range & Interval Filtering: Performance

**Performance:**

- Index date and numeric columns

- Use >= and < instead of BETWEEN for dates

- Avoid functions on indexed columns (WHERE DATE(created_at))

- Consider partitioning for large time-series data

Index columns used in range filters

Use >= and < for better index usage

Avoid DATE() function on indexed columns

Consider partitioning for time-series data

Use covering indexes when possible

BETWEEN includes both endpoints

Forgetting time component in timestamps

Using functions on indexed columns

Not handling time zones correctly

Reversed BETWEEN bounds (high, low)