OR condition query taking too long to execute 3 node vertica cluster
I have a 3 node vertica cluster, I have 2 equally segmented tables on all the nodes when I try executing OR query for just a 5million records in each table it is taking around 20minutes to execute query. How can I reduce the execution time.
Problem is only with OR all other scenarios are working fine. I am using INNER JOIN for the tables. I have tried with both projections segmented, 1 unsegmented and 1 segmented but no improvement in the query performance. Please suggest
Except OR, all other conditions are executing within 1 minute for same set of data