I have created a column store table on memsql 7.0. But it is taking more time to respond. Please provide the Tuning tips for columns store table.
This is going to depend upon a number of factors. Primarily how the queries execute in relation to your table design. How has the data been inserted, this may dictate whether or not you need to do an OPTIMIZE. Do you have data skew?
Without knowing the queries, and structure, it is a bit of a shot in the dark. But you can also look at the explain/ visual explain of your SQL statement to begin to understand what is going on with the optimizer.