Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
Create a Database
After deploying your cluster, you are ready to create a database.
This guide explains how to create a database using the CREATE DATABASE command.
In this section
- Choosing a Table Storage Type
- Columnstore
- Creating a Columnstore Table
- Configuring the Columnstore to Work Effectively
- Rowstore
- Understanding Keys and Indexes in SingleStore
- Understanding Shard Key Selection
- Understanding Sort Key Selection
- Understanding How Datatype Can Affect Performance
- Using JSON
- Multi-Value Hash Index (JSON)
- Using Persistent Computed Columns
- Other Schema Concepts
- Detecting and Resolving Data Skew
- Optimizing Table Data Structures
- Specifying Unenforced Unique Constraints
Last modified: June 5, 2025