The Heavy Horse Archer has more hit points and attack strength than the Horse Archer. You must research Chain Mail for Archers before you can train the Heavy Horse Archer.
Researching Nobility increases hit points. Researching Alchemy increases attack strength. Ballistics increases accuracy. Leather Armor, Scale Armor, and Chain Mail increase armor. Woodworking, Artisanship, and Craftsmanship increase range.