What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes.
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Recommended Answers
Jump to PostI'm not very familiar with HAVING but my understanding is that it is used to filter results after a GROUP operation so I can't imagine that indexes would improve performance other than on the original SELECT. Using WHERE would return rows based on one or more criteria, and would benefit …
Jump to PostPerhaps a smarter someone on this forum can help you look at the execution plan of your query and suggest some improvements.
Jump to PostI have a friend who spent the better part of a career doing SQL. I wrote up your question and sent it off to him. Just for sh!ts and giggles, he decided to feed it to ChatGPT first. He said that what he got back was what he would have …
All 35 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Dani
commented:
Keep It Clear: Do not post spun or AI-generated content
-8
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Dani
commented:
It did depend on GROUP. I spent hours and hours rewriting the query to be able to remove it.
+34
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
commented:
Now you are just splitting hairs
-3
AndreRet
commented:
Hence the quote and not posted as an answer...
+0
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
commented:
Works for me :-)
+0
AndreRet
526
Senior Poster
Reverend Jim
commented:
Sorry to see you go.
+15
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Biiim
182
Junior Poster
Dani
commented:
Thank you for bringing this topic back on track!
+34
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Biiim
182
Junior Poster
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
toneewa
81
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.