When you join maps that are based on different data sources, you can optimize the join by providing values for map and join column properties. Providing values for these properties improves the selectivity of the join. You should provide values for:
Cardinality specifies the number of rows returned by the map, or gives an approximation based on the possible parameter values.
Max Value and Min Value are not used for columns of character data type. When providing values for Max Value and Min Value, use the appropriate format. For example, if the column is of type TIMESTAMP, Max Value must be in the following format:
