In heavy clay soil like we have in many areas along the Front Range, adding some sand may help with drainage. But adding to much can turn the soil into an adobe like substance which will hinder drainage not improve it.