8.5.5 Global Hints

Table of Contents Previous Next



hint(view.table)
A view named, tx, is created from the three-table join of history, branches, and accounts shown in the final example of Section 8.5.3.
In addition to applying hints to tables within stored views, hints can be applied to tables within subqueries as illustrated by the following example. In this query on the sample application emp table, employees and their managers are listed by joining the emp table with a subquery of the emp table identified by the alias, b.
A hint can be applied to the emp table within the subquery to perform an index scan on index, emp_pk, instead of a table scan. Note the difference in the query plans.


Table of Contents Previous Next