The Matrix Distance is just a wrapper around a distance matrix column. This reduces the evaluation of a distance measure between two data points to a simple lookup in the distance matrix. The Matrix Distance should be used if the distance measure evaluation is costly and also performed multiple times. For example if you use the Aggregated or Java Distance in combination with the hierarchical clustering node or if you use the same distance in two branches of the workflow.