When you have decided whether to create an in-memory or disk-based table (see Deciding which tables to designate as in‑memory 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 SQL statements, see CREATE TABLE and ALTER TABLE.
▪ Specify the default table location with the General.DefaultStoreIsMemory parameter. For example:
[General] DefaultStoreIsMemory=yes
– If the parameter is set to yes, new tables are created as in-memory tables unless specified otherwise in the CREATE TABLE statement.
– If the 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.