SQL Joins vs Single Table : Performance Difference?

Keep the Database normalised UNTIL you have discovered a bottleneck. Then only after careful profiling should you denormalise.

In most instances, having a good covering set of indexes and up to date statistics will solve most performance and blocking issues without any denormalisation.

Using a single table could lead to worse performance if there are writes as well as reads against it.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)