Database - What is denormalization?

What is denormalization?

The process of adding redundant data to get rid of complex join, in order to optimize database performance. This is done to speed up database access by moving from higher to lower form of normalization

What is denormalization?

Redundant data addition for optimizing the performance of a database, denormalization is the process. The inefficiencies those inherit in RDBMS software are addressed with denormalization. It is a process of combining data into a single table. Denormalization structures are used in databases for providing quick access for a specific user needs.
Database - Explain DML and DDL statements
Data definition language is used to define and manage all attributes and properties of a database....
Database - What is Union and Union All operator?
UNION is a set operator combines the relations of 2 or more select statements into one relation....
Database - What is cursor?
A cursor is a variable that represents an area where the result of a query is stored....
Post your comment