Timeline for No index used warning in WHERE column IS NULL
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 20, 2021 at 6:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 16, 2021 at 4:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 15, 2021 at 6:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 15, 2020 at 6:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 23, 2019 at 15:18 | comment | added | Rick James |
For an INDEX, NULL is a value. There as many 'rows' in an index as there are rows in the data, regardless of whether some (or all) of the values are NULL.
|
|
| Jun 23, 2019 at 15:03 | comment | added | IMB | @RickJames What I mean is there's no actual index internally yet since most records are null, but then I don't know what's actually going on inside. | |
| Jun 23, 2019 at 13:52 | answer | added | Rick James | timeline score: 2 | |
| Jun 23, 2019 at 13:45 | comment | added | Rick James |
"there's literally no index" disagrees with the SHOW you provide.
|
|
| Jun 23, 2019 at 11:51 | answer | added | RolandoMySQLDBA | timeline score: 0 | |
| Jun 23, 2019 at 11:11 | history | asked | IMB | CC BY-SA 4.0 |