There are three types of maintainers, and only two of them are good.
The first type is the trickle charger. This generally supplies a constant 2A charge to the battery. It will cause constant water loss and can damage the battery, so I don't recommend them at all.
The second type is known as a float charger. This charger maintains the battery at its float voltage, which is generally around 13.2-13.4V. The battery draws very little current at this voltage, and the charge just adds enough to offset self-discharge of the battery. Water loss is low with a float charger.
The third type incorporates a timer. The charger turns on once every 24 hours and applies a charge to the battery until the current draw drops below about an amp. Once that happens, the charger goes back to sleep. Water loss is low with this type of charger too.
The float and timed chargers are often combined into a full capability charger, and the maintenance mode comes on after the charge process is complete. These chargers are usually marketed as 3-stage or 4-stage chargers or smart chargers.
Whatever you use, if your battery has vent caps, check the electrolyte level about every 30 days if you have a charger connected. As a battery ages, it can begin using more water.