What is better SELECT * or SELECT field names

[anand99]

What is better to use when retrieving all the fields from a table when making a query along one of the following lines

SELECT * FROM Customer WHERE CustomerID = 4

SELECT * FROM Accounts WHERE AccountID = 100 AND Customer ID = 4

What is better individually listing each field name in the query or using *. What is more faster and more efficient. Thanks for your help