How does database query optimization work?