Lets say I have a table
id col1 col2 col3 1 ABC DEF XYZ 2 AAA BBB CCC
Most frequent queries is going to be
SELECT * from XYZ where col1='abc' and col2='def'
SELECT * from XYZ where col1='abc' and col2='def' and col3='xyz'
As per VoltDB docs:-
1. Partition should be done on column on which most searches are going to be performed
2. Partitioning should be done on one column
I couldn't find any example where search is performed on multiple columns.
I wonder what is the best way to partition table for multi column searches?