Revisions to A better way to write this query?

added [postgresql-performance] to 571 questions - Shog9 (Id=1924)

Link

edited Jan 7, 2020 at 22:25

Community Bot

1

Notice removed Reward existing answer by ypercubeᵀᴹ

occurred Dec 26, 2017 at 16:30

Bounty Ended with Erwin Brandstetter's answer chosen by ypercubeᵀᴹ

occurred Dec 26, 2017 at 16:30

Tweeted twitter.com/StackDBAs/status/944947238995980288

occurred Dec 24, 2017 at 15:05

Notice added Reward existing answer by ypercubeᵀᴹ

occurred Dec 24, 2017 at 12:18

Bounty Started worth 300 reputation by ypercubeᵀᴹ

occurred Dec 24, 2017 at 12:18

add tag

Link

edited Nov 5, 2017 at 16:30

Erwin Brandstetter

186.5k
28
465
639

postgresql subquery performance relational-division

added 2 characters in body

Source Link

edited Nov 5, 2017 at 14:58

H.Rahimy

153
4

At a high level, this query is supposed to return PulledTexts whose IDs match those returned by the subqueries. The subqueries are simply meant to return the list of IDs of PulledTexts that contain lets say ('audit' AND 'trial') OR 'automate'('audit' AND 'trial') OR 'automate' from the UniqueWords table. This is exactly what the example query I gave does. The WordTexts table is a simple mapping of UniqueWord to PulledText.

At a high level, this query is supposed to return PulledTexts whose IDs match those returned by the subqueries. The subqueries are simply meant to return the list of IDs of PulledTexts that contain lets say ('audit' AND 'trial') OR 'automate' from the UniqueWords table. This is exactly what the example query I gave does. The WordTexts table is a simple mapping of UniqueWord to PulledText.

At a high level, this query is supposed to return PulledTexts whose IDs match those returned by the subqueries. The subqueries are simply meant to return the list of IDs of PulledTexts that contain lets say ('audit' AND 'trial') OR 'automate' from the UniqueWords table. This is exactly what the example query I gave does. The WordTexts table is a simple mapping of UniqueWord to PulledText.