Performance of IN clause with Binary values

Binh_1Binh_1
in General Discussion

Hi,

 

I was told that when using an IN clause with binary values, Vertica splits the IN statement into an equivalent number of OR statements behind the scene.  Is this correct?  If so, then doing so with a large number of values affects the query running time.  Is there a way to address this performance?

 

Thanks!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...