Does SingleStore support compression?

Yes, column store tables are compressed by default.

Does SingleStore perform random IO?

No, only sequential IO is used by SingleStore.

What are the index types SingleStore supports?

The in-memory row store supports skip lists, hash tables and geospatial indexes. The on-disk column store supports ordered columnstore, hash tables, and full-text search indexes. Refer to Understanding Keys and Indexes in SingleStore for more information.

Last modified: January 10, 2023

Was this article helpful?