Hacker News new | ask | show | jobs
by LunaSea 1488 days ago
As far as I know, nested loop semi joins using EXISTS aren't always capable of using indexes.

Like in the case of a GIN indexed array intersection.