About the Leading Hint

A Leading hint forces the optimizer to build the join order of a query with a specific table.

See Oracle hints in the SQL reference guide for the version of the Oracle Database that you use.

This is the syntax for the Leading hint:

leading(table_name)

For example, suppose you have a join between the Sales Fact table and the Products table and want to force the optimizer to begin the join with the Products table.

For this example, you add this syntax to the physical join's Include Hint field:

leading(Products)