How do you design and optimize SQL queries to handle large datasets containing millions of meter reads?
