Hello to all! How can I optimize this query
select * from table where col1 = 5 && col2 = 15; If I know that col2 I have 150000 rows and col1 I have just 100 rows, I know that because I save that data in another table. How can I do for search first where is minus number of result? The two columns are indexes. Thanks to all.