Retirement visa requirements — different from what my acquaintance said. Which is it?

I have two kids in elementary school, so I started by looking at school catchment areas and now I'm considering long-term residency in Dubai. An acquaintance who moved earlier first mentioned a retirement visa, then later said I'd have to switch to a golden visa, so I can't get a fix on the criteria. What are the actual requirements?