What is de-normalization and when do you do it?
Answers were Sorted based on User's Feedback
Answer / swapna
As the name indicates, denormalization is the reverse
process of normalization. It's the controlled introduction
of redundancy in to the database design. It helps improve
the query performance as the number of joins could be
reduced.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / praveen
Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / praveen
If the database developer might want a reversal of
normalization to improve performance is called
denormalization.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to update multiple rows with one update statement in ms sql server?
How will you collect the date from current date to last older 6 days date in sql server 2005
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
what is create database syntax? : Sql server database administration
Do you know what is similarity and difference between truncate and delete in sql?
What is normalization in Database ?
What command do we use to rename a db, a table and a column?
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
How to define output parameters in stored procedures?
How many types of triggers are there?
Why use cursor in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)