User Guide : 3. Vector Concepts : Storage Structures
 
Share this page                  
Storage Structures
A Vector table can be created with one of two storage types:
VECTORWISE
(Default) Stores data in columns. Puts as few columns as possible in one disk block (in most cases only one).
VECTORWISE_ROW
Stores data in rows. Puts as many columns as possible in one disk block.
In one block, values are still kept in compressed vectors. Potentially, all columns in a row can be stored in a disk block. This type is useful for small tables, especially those with a large number of columns; it saves disk space and disk cache memory.
The result_structure parameter in config.dat sets the default storage structure for the Vector instance. When a table is created, the default storage structure is assumed.
To override the default, specify SET RESULT_STRUCTURE for the session or use WITH STRUCTURE=vw_structure in the CREATE TABLE statement.
You can create a traditional Ingres table in a Vector instance by overriding the default storage setting on a table basis by using WITH STRUCTURE = HEAP in the CREATE TABLE statement.
Note:  You must be licensed to use HEAP tables in Vector.