Is "Don't ask don't tell" good military policy?

If it is repealed what would be the impact or the reaction within the ranks? Hard to imagine how that would work. Does this mean soldiers of the same can hold hands while in uniform? Honestly, I don't know.