Re: Optimizing `WHERE x IN` query

[Thomas Kellerer]

Omar Roth schrieb am 07.07.2019 um 15:43:

Currently, the query I'm using to generate a user's feed is:

```
SELECT * FROM channel_videos WHERE ucid IN (SELECT unnest(subscriptions) FROM
users WHERE email = $1) ORDER BY published DESC;
```

You could try an EXISTS query without unnest:

select cv.*
from channel_videos cv
where exists ucid (select *
                   from users u
                   where cv.ucid = any(u.subscriptions)
                     and u.email = $1);

Did you try if a properly normalized model performs better?