Documentation Home
HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 2.1Mb
PDF (A4) - 2.1Mb


HeatWave User Guide  /  ...  /  Autopilot Indexing Syntax

2.8.1.1 Autopilot Indexing Syntax

Autopilot Indexing uses the following syntax:

Press CTRL+C to copy
mysql> CALL sys.autopilot_index_advisor ([options]); options: { JSON_OBJECT('key','value'[,'key','value'] ...) 'key','value': ['output',{'normal'|'silent'|'help'}] ['target_schema',JSON_ARRAY({'schema_name'[,'schema_name']}] }

Autopilot Indexing options are specified as key-value pairs in JSON format. Options include:

  • output: Defines how Autopilot Indexing produces output. Permitted values are:

  • target_schema: Defines one or more schemas for Advisor to analyze. The list is specified as a JSON array. If a target schema is not specified, Advisor analyzes all user defined schemas. When a target schema is specified, Advisor generates recommendations for tables belonging to the target schema. For the most accurate recommendations, specify one schema at a time. Only run Advisor on multiple schemas if the queries access tables in multiple schemas.