You have the best SELECT command. However, you may not have the best schema to keep time and processing to a minimum. Do this … <code> CREATE INDEX test_available ON test (available)</code> … just once. Then try the SELECT command again. PS: I see that this is just a test, but other people may find this code, so I remind them it is considered bad style to use 'SELECT *' in real production code. You should name the columns you want.