Properties of static limit and rotating equilibrium sequences of compact stars: Systematic correlations and constraints