New join optimization filters

Two new filters are available to optimize joins. The two filters are: Unique values in a subquery and Unique or range of values.

For more information, see Join optimization filters.