3 ms·
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.
by LunaSea 4y 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.