3 ms·
I think it hugely depends on what your WHERE clause is.
by ris 9y ago
I think it hugely depends on what your WHERE clause is.
- throwaway-1209 9y agoI guess if your where clause is very selective, you could avoid the hit since the same branch is taken by all threads in a warp. But then there are better approaches such as BRIN indexes, RLE and dictionary encoding with which you don't even touch the data that doesn't match your clause.