Build indexes based on recommendations

Then we will see how Kyligence AI-Augmented engine can help to accelerate the query.

  1. 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.

  2. 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.

  3. In the Model List on the Model page, click the icon to view the recommendation.

  4. Select the recommendation and click Accept, and then click Add in the confirmation dialog page.

  5. On the same page, click the Index Overview tab. Select the recommended aggregate index and click the Build Index icon.

  6. Click Add in the Add Items to Model dialog box.

  7. Select the data range and click the Build Index button in the confirmation dialog box.

  8. To check the process, you may click Job in the left navigation pane.

[!Note]

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

Copyright © Kyligence Inc. all right reserved,powered by GitbookLast Modified: 2022-05-20 17:20:50

results matching ""

    No results matching ""