This repository has been archived by the owner on Feb 20, 2023. It is now read-only.
Generate vectorized selection filters for IN. #1340
Labels
beginner
Good for newcomers. Mark issues with this.
performance
Performance related issues or changes.
Feature Request
Summary
Right now,
foo IN (1,2,3)
is translated tofoo = 1 OR foo = 2 OR foo = 3
.Per Prashanth's suggestion in #1326, we can go HAM with IN (I am suddenly fond of this phrasing) and translate IN to use vectorized selection builtins for each value in the IN list.
I think this would mainly involve a tweak to where filters are currently being generated in SeqScanTranslator::GenerateFilterClauseFunctions (and perhaps CTE scan, whenever that eventually merges). We already generate the vectorized select for the = case.
The text was updated successfully, but these errors were encountered: