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.
One post tagged with "partial index"
View All TagsTwo queries. Same result. One is 26x faster — and it reads 53x fewer disk pages.
The difference is one word: NOT.