AI agents/LLMs: Fetch /llms.txt first to access the documentation index. Remove the trailing slash and append .md to any URL to access lighter, easier-to-parse Markdown pages instead of HTML (this page is accessible at https://docs.singlestore.com/db/v8.9/introduction/faqs/miscellaneous.md).
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.