Optimize

Optimize lets you build an index into a dataset using specified columns, allowing for fast access for later queries.

Format

Optimize uses a single utterance: Optimize access to the dataset <dataset name> for the columns <columns>

Parameters

Optimize uses two parameters:

• dataset name (required). The dataset you’d like to optimize access to.
• columns (required). The columns you want to use to build the index.

Output

If the index is successfully built, a success message appears in the chat history. Otherwise, an error message appears.

Examples

To create an index using the Happiness and HealthyLifeExpectancy columns to optimize queries on the Happiness2021 dataset, enter Optimize access to the dataset Happiness 2021 for the columns Happiness, HealthyLifeExpectancy.