There is a clustered columnstore index on the table. MemSQL doesn’t support “filtered” indexes (indexes that let you specify a where clause that can be matched in a query with an equal or stricter where clause). Since the query needs a full scan those don’t help anyway.
We partition data on stock symbol but this doesn’t make a difference for this query either. It would if we had filters.
We partition data on stock symbol but this doesn’t make a difference for this query either. It would if we had filters.