If the amount of data in the table is small, the optimizer may estimate that a full table scan is faster, especially if the query is not an index-only scan.A quick experiment would be to change the SELECT to only read indexed fields, and/or to only r...