Structure

Fields and options used to segment the table.

You can group together, or segment, like information in the saved table. A table must be segmented before g_functions or Time Series functions can be used to analyze the data in the table. For Time Series functions, a minimum of three columns must be identified.

Figure 1. Structure tab in the Save Data as Table window

Target segment size

The maximum number of rows in the table to include in a single segment. The default is 4 million rows and, in general, should not be adjusted.

However, if the saved table will be used for aggressive expanding purposes, the maximum number of rows in each segment may need to be reduced. Contact 1010data Support to discuss your needs and we will help you determine the appropriate setting.

Columns to segment by

Specifies one or more columns that will be used to segment the table.

This type of segmentation is referred to as segby. If a table is segby a given column, no unique value of the column can be found in more than one segment.

For more information, see segby.

Sort segments by

Specifies one or more columns that will be used to sort and segment the new table.

This type of segmentation is referred to as sortseg. If a table is sortseg on a particular column, not only are unique column values not allowed to be found in different segments, the segments themselves are internally sorted on the sortseg column.

For more information, see sortseg.

Sort within segments by

Specifies one or more columns that will be sorted within each segment.

Columns to be indexed

Specifies which columns in the resulting table should be indexed.

Indexing provides increased selection performance at the cost of storage.