Storage Allocation
Analytics Engine allocates storage on a per column group basis. A column group is defined by the columns that are stored together, which is generally a single column unless you use multi-column indexes, or X100_ROW storage. Temporary space is stored in separate temporary files.
Analytics Engine files are deleted when the storage space is not required anymore. That is, files for temporary use are deleted when operations finish, and data files are deleted when tables or columns are dropped, or tables are truncated.
Note: Files do not shrink when data is deleted unless the table is truncated. Analytics Engine will first reuse empty data blocks in the file before extending it, if there is enough consecutive space available in the file.
For more information see the Analytics Engine User Guide.
Last modified date: 09/11/2026