Since normalization has some well known advantages such as improved indexing, compact databases with less additional records and update performance improvement, I thought of writing about the disadvantages of normalization.
- More Joins - The more joins you use, it will cause more locks to the database, so we should avoid multiple joins when ever possible.
- Performance degrade in data retrieval (SELECT)
Because of that in data warehousing which is used for reporting and analysing, we normally use un-normalized form of data as number of retrievals are greater than inserts and updates.
No comments:
Post a Comment