Differences
This shows you the differences between two versions of the page.
|
database:analyse-indexes [20/04/2018 12:25] Anthony Arents |
database:analyse-indexes [20/04/2018 12:42] (current) Anthony Arents |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Analyse indexes ====== | ====== Analyse indexes ====== | ||
| - | ===== Full ===== | + | |
| + | ===== Things to take note of ===== | ||
| + | |||
| + | * Primary keys ARE needed, usually our exports have all primary keys, but you'll need to verify this. | ||
| + | * Remove double indexes | ||
| + | |||
| + | ===== Without Primary Key ===== | ||
| <code sql> | <code sql> | ||
| Line 247: | Line 253: | ||
| </code> | </code> | ||
| - | ===== Without Primary Key ===== | + | ===== With Primary Key ===== |
| <code sql> | <code sql> | ||
| Line 499: | Line 505: | ||
| ALTER TABLE `Kundenbedarf` | ALTER TABLE `Kundenbedarf` | ||
| - | ADD PRIMARY KEY (`mandantId`), | + | ADD PRIMARY KEY (`id`), |
| - | ADD UNIQUE KEY `id_ndx` (`id`); | + | ADD KEY `mandantId` (`mandantId`); |
| ALTER TABLE `Login` | ALTER TABLE `Login` | ||