The total amount of memory (in MB) to be used for query result sets. Memory is allocated dynamically up to this amount as required. Note that the specified value must be greater than 0.

Default is 1024

The number of threads used when querying the compressed data file.

Default is 2.

The directory for Data Vault temporary data files. To improve performance, use a local directory.

Default is <DataVaultServiceDirectory>/temp.

The directory location of a virtual file system. Instead of creating a number of temporary data files, the Data Vault Service stores the temporary files in a single file container.

If this parameter is absent or empty, the Data Vault Service uses the standard file system in the location specified by the TEMPDIR parameter.

The network location where temporary files for GROUP BY and ORDER BY queries are stored. This location must be accessible to any machine that runs the Data Vault Agent.

Default is <DataVaultServiceDirectory>/share.

The directory where the Data Vault stores index files when you create indexes for archived tables.

Default is <DataVaultServiceDirectory>/index.