Hacker News new | past | comments | ask | show | jobs | submit login

That doesn't answer the question at all.

The old statistics said to use the index.

If it's still using old statistics, why does the behavior change?




Because the user is using values that are no longer covered by the statistics. For example incrementing timestamp or id column. If the stats are from yesterday and they say nothing about the frequency of todays timestamps the query will have to take a pessimistic view of the world. It might be that the data has radically changed since the last stats run, or not. Need to analyze the table to know and make optimal choices.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: