This section describes join indexes. These indexes permit you to undertake a wide variety of physical denormalizations of the database without affecting the normalization of the logical and physical models.
Other topics include information on how to estimate the overhead of join indexes, Optimizer criteria for selecting a join index, special storage options offered by join indexes, and numerous examples.
See Design Issues for Tactical Queries for a description of the special design considerations that must be evaluated for using join indexes to support tactical queries.
The following content is mainly applicable to the standard nodes of the primary cluster in VantageCloud Lake and may not apply to compute clusters on the primary cluster.
For information about the primary cluster and compute clusters, see Managing Compute Resources.