Half join and cross join semantics
The optimizer uses several keywords in directed queries to recreate cross join and half join subqueries.
The optimizer uses several keywords in directed queries to recreate cross join and half join subqueries. It also supports an additional set of keywords to express complex cross joins and half joins. You can also use these keywords in queries that you execute directly in vsql.
Caution
These keywords do not conform with standard SQL; they are intended for use only by the optimizer.For details, see the following topics: