Optimizing a query in Hue

You can use the SQL AI Assistant to optimize a SQL query. Hue identifies the issues in the source query, optimizes it, and provides the optimized version of the SQL query. Hue also summarizes the issues and how it optimized the query in natural language.

Your administrator must have configured and set up the required infrastructure for you to use the SQL AI Assistant. See About setting up the SQL AI Assistant in CDW.

Log in to the Data Warehouse service as DWUser.
Open Hue corresponding to your Virtual Warehouse.
Insert a SQL query in the Hue editor that you would like to optimize.
Click Assistant on the Hue SQL editor:
Click OPTIMIZE.

Hue displays the original and the optimized SQL query side-by-side. It also provides an explanation of the issues in the original query and how it was optimized.