Timeline for Optimizing a distinct on a parent table in a multi-level join in MySQL 5
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 26, 2021 at 13:14 | vote | accept | waiwai933 | ||
| Aug 26, 2021 at 1:04 | answer | added | Rick James | timeline score: 1 | |
| Aug 25, 2021 at 19:09 | comment | added | Charlieface |
What about the second query, but with union all or as an or
|
|
| Aug 25, 2021 at 17:36 | comment | added | John K. N. |
Welcome to DBA.SE. It would help if we had the respective DDL of the tables involved, just to on the safe side, and possibly any indexes that may have already been created. Have you tried OPTIMIZE TABLE...? Otherwise a very decent first question. Good luck.
|
|
| Aug 25, 2021 at 13:04 | review | First posts | |||
| Aug 25, 2021 at 17:37 | |||||
| Aug 25, 2021 at 12:59 | history | asked | waiwai933 | CC BY-SA 4.0 |