When working with large data volumes or complex queries, use HINT statements in a dataset for more efficient data retrieval. Correctly applying HINT statements improves query performance, reduces response time, and makes better use of system resources.
Procedure
On the Model Configuration page, click the Set HINT Statement icon in the upper-right corner to set a HINT statement.
Alternatively, in the custom SQL editor, click the Set HINT Statement icon in the top menu bar and follow the illustrated steps to set a HINT statement.
For a list of data sources that support HINT statements, see Data source feature list.
HINT statements are not supported for cross-source joins between data tables.
You can set up to 20 HINT statements.
If you create a dataset using SQL code and then modify a HINT statement, you must rerun the SQL code to retrieve the data.
A HINT statement cannot exceed 50 characters and can only contain letters, digits, underscores (_), and periods (.).