News for hackers. Stuff that matters.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by stuhood on Monday November 16, 2026 @11:19AM (#50519299)
It very much depends which noun you are searching for (e.g., what the shape of your search results will be):

The central query in the blog would likely be the type of query you'd use for the default top-level search box on StackOverflow, which is searching for posts and comments (e.g. questions and responses). The reason to include users in that query is two fold: 1) posts/comments from users who are relevant to your query should get a higher score, 2) you need the users to render the search results page anyway.

If you were doing only user search, then I agree: you probably would only search the users table.

Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by amluto on Monday November 16, 2026 @11:58AM (#50519804)
If I’m searching for questions and answers, I don’t want an unrelated answer from a very high ranked user who happens to mention the topic in their profile.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by stuhood on Monday November 16, 2026 @12:10PM (#50519960)
Possibly, yea: scoring can be subtle. For a query like this, you'd likely significantly "boost" (e.g. multiply) the scores from the questions and answers to ensure that they are prioritized. But including the user score as essentially a tiebreaker can be helpful.