Interested to Buy Any Domain ? << Click Here >> for more details...
What is de-normalization and when do you do it?
- 3 Answers
- 8863 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 |
can you any body tell me the how to decrease the logfile
How to concatenate two binary strings together?
Diffrences between sql server 2000 vs 2008
What is the difference between migration and upgradation in sql server?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain the truncate command? : SQL Server Architecture
What is the default order of an order by clause?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
How will you know when statistics on a table are obsolete?
What is scalar user-defined function?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What do you understand by recursive stored procedures?
-
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)
