gitgud

# Coding Challenge: Optimizing Database Queries

**Difficulty Level:** Intermediate
**Language:** Python
**Topic:** Database Optimization

## Challenge Description

You are working on a project for a retail company that needs to optimize its database queries for better performance. The current queries are slow, and you need to refactor them to improve efficiency. Here's the initial code:

```python
import sqlite3

# Connect to the database
conn = sqlite3.connect('retail.db')
cursor = conn.cursor()

# Slow query
cursor.execute("""
SELECT * FROM orders
WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31'
AND customer_id = 12345
""")
orders = cursor.fetchall()
```

## Tasks

1. Identify the performance bottlenecks in the given query.
2. Refactor the query to use indexing and other optimization techniques.
3. Ensure the query is still returning the correct results.
4. Provide a brief explanation of the optimizations you made.

## Submission

Submit your optimized query and explanation. You will be scored on correctness, efficiency, and clarity of explanation.