Bug #96328 | INSERT ... ON DUPLICATE KEY UPDATE | ||
---|---|---|---|
Submitted: | 25 Jul 2019 10:37 | Modified: | 25 Jul 2019 13:04 |
Reporter: | HULONG CUI | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | all | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | Explain INSERT ... ON DUPLICATE KEY UPDATE type=all |
[25 Jul 2019 10:37]
HULONG CUI
[25 Jul 2019 13:04]
MySQL Verification Team
Hello Mr. Jacky, Thank you for your bug report. However, this is not a bug. For several reasons. First one is that INSERT usually does not need to use any indices. There are exceptions, like INSERT from SELECT etc ...... More important, when a table has a small number of rows, like less then 100 (one hundred), indices are not used since the scanning is much faster in that case. This is all fully explained in our Reference Manual.