Engine Settings for System-Defined Aggregates Only

There settings that you can use to influence the behavior of the AtScale engine with regard to system-defined aggregates. The settings apply to all of the aggregates that are in the organization for which an AtScale engine is registered.

For descriptions of the different types of aggregates, see Types of Aggregate Tables in AtScale.

• Settings for Enabling and Changing the Compression Factor Use these settings to specify a compression factor. This factor is a measure of the quality of a proposed aggregate. It is calculated as the number of rows in the fact dataset divided by the estimated number of rows in a proposed aggregate.
• Settings that are Related to Narrowing and Widening Use these settings to enable the narrowing and widening of aggregates.
• Settings for Prediction-Defined Aggregates These settings enable the AtScale engine to create prediction-defined aggregates.
• Settings for Specifying Whether and How to Use Joins These settings enable the AtScale engine to define aggregates that use joins and affect how it determines whether a join is appropriate for a given aggregate.
• Settings that Control Partitioning of System-Defined Aggregate Tables One of these settings enables the AtScale engine to partition instances of aggregate tables that it defines. The other setting lets you set a threshold for determining when to partition them.
• Other Settings for System-Defined Aggregates Only A number of features of system-defined aggregates are enabled or affected by single settings.