In all databases you will avoid bad plans (and the unpredictable performance related to plan changes) by providing the right index. You have two selective filte

In all databases you will avoid bad plans (and the unpredictable performance related to plan changes) by providing the right index. You have two selective filters: WHERE and LIMIT so the right index have both