MySQL Forums
Forum List  »  Performance

Re: slow update-join query
Posted by: Peter Brawley
Date: June 07, 2022 02:55PM

Your column renames leave us guessing what's what.

The relevant Explain result is that MySQL cannot find an index for table `t`, which needs an index on whatever col2,col3 are. If they're text, you'll need to specify indexing length.

And, using Float for a version number misuses that type. Be aware that float and double always return rounding errors. Not, probably, what you had in mind.



Edited 1 time(s). Last edit at 06/07/2022 03:09PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
251
June 07, 2022 12:55PM
107
June 07, 2022 01:00PM
105
June 07, 2022 01:19PM
115
June 07, 2022 02:27PM
Re: slow update-join query
108
June 07, 2022 02:55PM
103
June 07, 2022 03:26PM
118
June 07, 2022 05:06PM
99
June 07, 2022 06:20PM
114
June 08, 2022 09:51AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.