3 ms·
Yeah IN/ Not IN should be able to use index/hash scan when given normal values. I am under the impression from the note though that this is related to subquerie
by julienkervizic 7y ago
Yeah IN/ Not IN should be able to use index/hash scan when given normal values. I am under the impression from the note though that this is related to subqueries fitting in a IN/NOT IN clause, eg:
SELECT * FROM tableA IN (SELECT * FROM tableB)