Build indexes based on recommendations
Then we will see how Kyligence AI-Augmented engine can help to accelerate the query.
In the left navigation, click Home -> Recommend. The AI engine will check if there are any recommendations on how to improve performance based on your query history.
Then a message will pop up to indicate recommendations generated, click View details, or click Pending in the AI-Augmented Engine area to check the recommendations.
Select the recommendation and click Accept, and then click Add in the confirmation dialog page.
On the same page, click the Index Overview tab. Select the recommended aggregate index and click the Build Index icon.
Click Add in the Add Items to Model dialog box.
Select the data range and click the Build Index button in the confirmation dialog box.
To check the process, you may click Job in the left navigation pane.
The time to build indexes varies depending on the size of the source data and the complexity of the model. In this tutorial, it will take around 5 minutes.
Next step: Run SQL query again