We are facing to a terrible query performance issue. There are only 5 million rows in the table. And the we add in index on username, the query we run are always against the username. Both nscaned and nscannedObjects are 1, however it will take more than 100 ms.