Timeline for Speed up a MySQL BETWEEN query
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 28, 2014 at 15:44 | review | First posts | |||
| Aug 28, 2014 at 17:12 | |||||
| Aug 27, 2014 at 15:36 | history | edited | cassiopeia88 | CC BY-SA 3.0 |
added 846 characters in body
|
| Aug 27, 2014 at 15:33 | comment | added | cassiopeia88 | aha, so dateToFind is a column in table1 and dateFrom and dateTo are columns in table2. I have created a dummy table in my local to test , and it seems it will use the dateFrom_dateTo index, and for table1 is full table scan, which make sense because it needs to go through all the rows. | |
| Aug 27, 2014 at 15:07 | comment | added | ypercubeᵀᴹ |
dateToFind BETWEEN dateFrom AND dateTo is a condition.
|
|
| Aug 27, 2014 at 15:05 | history | answered | cassiopeia88 | CC BY-SA 3.0 |