Creating in-memory and disk-based tables

In-Memory Database Guide : Working with in-memory tables : Creating in-memory and disk-based tables

There are two ways to explicitly specify whether tables are to be located in-memory or on disk.

▪Use the STORE MEMORY or STORE DISK clause of the CREATE TABLE or ALTER TABLE command.

CREATE TABLE employees (name CHAR(20)) STORE MEMORY;
CREATE TABLE ... STORE DISK;
ALTER TABLE network_addresses SET STORE MEMORY;

For more information about the syntax of the CREATE TABLE and ALTER TABLE statement, see the solidDB^® SQL Guide.

▪Specify the default with the General.DefaultStoreIsMemory parameter. For example:

[General] DefaultStoreIsMemory=yes

where General.DefaultStoreIsMemory is set to “yes”, new tables are created as in-memory tables unless specified otherwise in the CREATE TABLE statement. If this parameter is set to “no”, new tables are created as disk-based tables unless specified otherwise in the CREATE TABLE statement.

Note These instructions apply to persistent tables only. Tables that are declared to be temporary tables or transient tables are automatically stored in memory, even if you do not use the STORE MEMORY clause.