What are the benefits of integer indexed fields compared to non integer indexed fields?
For example, in my MySQL database, I have a table for video games and one of the fields is developer. Right now those fields are filled in with the developer names but I was wondering if it'd be faster for my database if I made a separate table for developers and than referred to the developer using the id.
If doing this is better and/or faster, by how much? And what other benefits are there?