What are the benefits of normalizing a table in a database?

The following are some of the benefits of normalization:

1. removes redundancies

2. achieves consistency.

3. improves data accessing speed

4. improves the performance of the server

5. decreases time accessing from the database.

6. generally efficient working of the application

Normalization was introduced just to have CONSISTENT Data by avoiding REDUNDANCIES. While doing so, it introduces some overhead by having few new tables which definitely has an impact over PERFORMANCE and SPEED, because of involving many tables in the JOIN operation which itself proves the complexity. In short, you can prefer normalization for having Consistent and Clean Data with the cost of Performance and Speed.