The type of sand has a great impact on the maintenance required. Siler sand, building sadn and so forth tends to pack down very hard in a short time so raking it around is a frequent activity. For the last 10+ years I have used swimming pool filter sand which I find packs down softly over a long period, just a poke about with a chopstick once in a while.
Don't get coral sand or any other calcareous stuff, if it fizzes with vinegar, it is not suitable unless you are keeping rift valley species or marines.