Does SingleStoreDB support compression?

Yes, column store tables are compressed by default.

Does SingleStoreDB perform random IO?

No, only sequential IO is used by SingleStoreDB.

What are the index types SingleStoreDB 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?