GX-Bug #70120
Von Moritz Bunjes vor etwa 2 Jahren aktualisiert
The SQL query
```
UPDATE `address_book` ab LEFT JOIN `zones` z ON z.`zone_name` = ab.`entry_state` SET ab.`entry_zone_id` = z.`zone_id` WHERE ab.`entry_zone_id` = 0 AND z.`zone_id` IS NOT NULL;
```
is too slow, because of a missing INDEX of zones.zone_name.
```
ALTER TABLE `zones` ADD INDEX `zone_name` (`zone_name`);
```
10000 customer addresses need for example 55 seconds for the update on a local server environment.