Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
Create a Database
Note
As a database is automatically assigned to you in a SingleStore Helios Shared Edition cluster, additional databases cannot be created.
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: