Optimal Correlations in Many-Body Quantum Systems