It depends what you are keeping. Ive seen beautiful tanks that did 6 month water changes and beautiful tanks that did weekly. It depends on nutrient export, your nitrate levels, and additives that your replenishing the missing minerals and trace elements with.
Rule of thumb is to do weekly 10-15% water changes, or if thats too much a nice larger one once a month, like 20-30%. There is no right and wrong answer. And the reason your doing them is because you need to remove nitrates and Po4 from the water, as well as replenish calk/alk if your not dosing and any trace elements and minerals that your coral are soaking up in their growth process. Doing regular water changes keeps things like iodine, stront, mag, ect all in their normal ranges. And it really depends what your keeping in your tank. A LPS and anemone tank will do better in 3 month water change tanks than SPS and vice versa most times. With more frequent water changes your going to see better growth and color most of the time, that is if everything else in your system is set up right.
Its usually a bad idea to take fish store advice from most places.