soldering materials

has anyone made a comparison between tin based solder vs silver solder vs copper solder ?

while on the subject of solder, what is the ideal intercae between connector and wire ?

is it solder, is it crimp, is it welding, any other method ?