Miscellaneous

Does SingleStoreDB Cloud support compression?

Yes, column store tables are compressed by default.

Does SingleStoreDB Cloud perform random IO?

No, only sequential IO is used by SingleStoreDB Cloud.

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