SQL is neither the fastest nor the most elegant ... The query optimizer has to figure out by itself what indexes to use to avoid brute force table scans and achieve good query performance, unless ...