# stardog-admin db optimize Manual Page

# NAME

stardog-admin db optimize —Optimizes the indexes of a database for query answering and disk utilization

# SYNOPSIS

stardog-admin [ --krb5 ] [ --krb5-disable-rdns ] [ --server <server url> ] db optimize [ --no-space-check ] [ --no-throttle ] [ {-o | --option} <options>... ] [ {-p | --passwd} <password> ] [ {-P | --ask-password} ] [ --run-as <username> ] [ --token <token> ] [ {-u | --username} <username> ] [ {-v | --verbose} ] [--] <database>

# OPTIONS

--krb5
Use the Kerberos environment.
--krb5-disable-rdns
Disable reverse DNS lookup for Kerberos clients.
--no-space-check
Override server's detection of too low storage space. Low storage space could force a server into read-only mode and subsequent restart.
--no-throttle
Disable Stardog's default configuration to intentionally throttle the optimize operation.
-o <options>, --option <options>
One or more configuration options to be used for optimization. Each option is a 'key=value' pair; multiple options are separated by whitespaces and the string should be quoted, e.g., '-o "option1=value1 option2=value2"'.
-p <password>, --passwd <password>
Password.
-P, --ask-password
Prompt for password.
--run-as <username>
User to impersonate when running the command
--server <server url>
URL of Stardog Server. If this option isn't specified, it will be read from JVM argument 'stardog.default.cli.server'. If the JVM arg isn't set, the default value 'http://localhost:5820' is used. If server URL has no explicit port value, the default port value '5820' is used. Example: 'stardog-admin --server http://12.34.56.78:5820 server stop'
--token <token>
Stardog JWT token
-u <username>, --username <username>
User name.
-v, --verbose
Flag that can cause more detailed information to be printed such as errors and status. Exact output depends upon the command and options used.
--
This option can be used to separate command-line options from the list of argument, (useful when arguments might be mistaken for command-line options
<database>
The name of the database for the operation

# DISCUSSION

Optimizes the indexes of a database for query answering and disk utilization after the database has been heavily modified. If a database has been modified with a large number of additions or removals, some internal structures may become less optimized for query answering. This utility will perform several operations that will help with query answering performance. Which operations are performed depends on the options given. Currently supported options:
* optimize.statistics={true, false}: recomputes the selectivity statistics which is used for query optimization
* optimize.compact={true, false}: compacts the index data structures after update operations
* optimize.vacuum.data={true, false}: frees space by removing quads which have been previously deleted from the database
* optimize.vacuum.dictionary={true, false}: optimizes internal encoding of RDF terms, removes terms which no longer appear in the data
* optimize.search={true, false}: recomputes the full-text search index

# EXAMPLES

Optimize the database 'myDb':

        $ stardog-admin db optimize myDb