When processing large volumes of data or performing complex query operations, setting HINT statements in datasets ensures that data retrieval processes are as efficient as possible. By appropriately applying HINT statements, you can improve query performance, reduce response time, and better utilize system resources.
Operation instructions
You can click the Set HINT Statement icon in the upper right corner of the Model Configuration interface to Set HINT Statement.
You can also click the Set HINT Statement icon in the menu bar at the top of the Use Custom SQL Statement to Create a Dataset editing page to Set HINT Statement according to the steps shown in the image.
For data sources that support HINT statements, see Data Source Function Item List.
HINT statements are not supported when tables are associated across different data sources.
You can set up to 20 HINT statements.
When creating a dataset using SQL, if you modify the HINT statement, you need to run the SQL code again to retrieve the data.
The input content is limited to 50 characters and only allows English letters, numbers, underscores, and periods.