Create Physical Table Hints

You can add SQL hints to a physical table. You can't add hints to an alias table, but only to its source table.

Although hints are identified using SQL comment markers (/* or --), don't type SQL comment markers when you type the text of the hint. The Oracle Analytics query engine inserts the comment markers when the hint is run.

For a description of available Oracle hints and hint syntax, see SQL reference for the version of the Oracle Database that you use.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon.
  4. In the database pane, browse for and double-click the table where you want to add a SQL hint.
  5. Click the General tab, and in the SQL Hints field enter the SQL hint.
  6. Click Save.