Timeline for Why search by date field requires engine to touch all records?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 19, 2014 at 2:42 | comment | added | Greg | I would look at the cardinality that MySQL is reporting. We have had cases where MySQL has the cardinality wrong and we had to run ANALYZE on the table. | |
| May 18, 2014 at 6:05 | comment | added | Budda | There are very few records that have same value in realdate field. I believe around 2-3 percents, not more. | |
| May 18, 2014 at 3:22 | history | migrated | from stackoverflow.com (revisions) | ||
| May 18, 2014 at 2:30 | history | answered | Greg | CC BY-SA 3.0 |