We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Performance of IN clause with Binary values — Vertica Forum

Performance of IN clause with Binary values

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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.
Home • General DiscussionComment As ...