Interested to Buy Any Domain ? << Click Here >> for more details...
What is de-normalization and when do you do it?
- 3 Answers
- 8909 Views
- I also Faced
- E-Mail Answers
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 |
What is collation sensitivity?
what is difference between NULL and ISNULL in SQL Server 2008?
What are the different types of stored procedures?
How do we know if any query is retrieving a large amount of data or very little data?
How many types of system privileges are there, Can we add or delete privileges?
Explain acid?
can a table be moved to different filegroup? : Sql server administration
How to get the query of a table in sql server?
What is local temp table?
what is the difference between Delete and Truncate command in SQL
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
How to delete a database in ms 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)
