it would do the most benefit on the SW tank. too much freshwater to see much of an affect. i really think the sterilizers are under powered. i keep one of the large ones on a ten gallon tank and honestly, i dont feel that it is over kill.
on fresh water it does pretty much the same as it does in salt: keeps the water super freaking clean.