Timeline for Time taken to drop/add index is lesser than adding a column. Why is that?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 10, 2018 at 17:37 | comment | added | Rick James |
There is no renumbering. There is no concept of "5th row", except by using ORDER BY ... LIMIT 5,1; it is not done when inserting/deleting.
|
|
| Dec 10, 2018 at 15:46 | comment | added | Mark Stewart | The original question deals with why adding a new column takes longer than dropping/recreating an index. The additional time for adding a new column to a huge table entails potentially allocating additional storage to the database for each row of the large table. Dropping and recreating an index (if the index does not include the new column would not require any new space to be allocated. | |
| Dec 10, 2018 at 14:35 | review | First posts | |||
| Dec 10, 2018 at 15:46 | |||||
| Dec 10, 2018 at 14:33 | history | answered | Jo......... | CC BY-SA 4.0 |