How NOT EXISTS beat EXISTS by 26x โ index size and heap fetches
ยท 4 min read
Two queries. Same result. One is 26x faster โ and it reads 53x fewer disk pages.
The difference is one word: NOT.
Two queries. Same result. One is 26x faster โ and it reads 53x fewer disk pages.
The difference is one word: NOT.