SingleStore Managed Service

Does SingleStore DB support compression?

Yes, column store tables are compressed by default.

Does SingleStore DB perform random IO?

No, only sequential IO is used by SingleStore DB.

What are the index types SingleStore DB supports?

The in-memory row store supports skip lists, hashtables and geospatial indexes. The on-disk column store supports ordered columnstore indexes.