Indices

Hi,
Having to manny indices to a table,does it effect the performance of a table.Like
a table having following structure

Name :       First name,      Second Name,      Third name,      Age,      Address.

Is it good here to have multiple indices like on only first name, only second
name,only third name and all other combination of first ,second and third name
or the performance increases when we have only 1 indice of all first ,second
and third name
Thanks
-Sharmad