It is possible to describe inconsistent plans using hints, such as this plan that specifies contradictory join orders:
(hints
(g_join
(scan t2)
(scan t1)
)
(g_join
(scan t1)
(scan t2)
)
)
When the query associated with the plan is executed, the query cannot be compiled, and an error is raised.
Other inconsistent hints do not raise an exception, but may use any of the specified access methods. This plan specifies both an index scan and a table scan for the same table:
(hints
(t_scan t3)
(i_scan () t3)
)
In this case, either method may be chosen, the behavior is indeterminate.
