Create Physical Join Hints

You can add SQL hints to a physical join in an alias 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. Hover over a table and right-click. Select Show Physical Diagram and the diagram type you want to work from.
  5. Double-click a join.
  6. In Edit Physical Join, click the Include Hint field and enter the SQL hint.
  7. Click Save.