New answers tagged comments
7
votes
Accepted
Search for comments on posts with a certain tag based on a keyword
You can cut back on an extra join because PostTags has the PostId and you don't seem to project any attributes from the Post table. Furthermore improve the LIKE performance with a COLLATE instead of ...
- 85.7k
5
votes
Search for comments on posts with a certain tag based on a keyword
I think I've cracked this one, and I've got a few tips to offer that might be able to help with speeding up SEDE queries for you in the future as well.
Here's my modified version of your query:
...
- 8,273
Top 50 recent answers are included