2 ms·
I 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 appro
by throwaway-1209 9y ago
I 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.