Interested to Buy Any Domain ? << Click Here >> for more details...
What is de-normalization and when do you do it?
- 3 Answers
- 9076 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 are the properties of the transaction?
What is difference between TRUNCATE and DELETE statement
Can you type more than one query in the query editor screen at the same time?
Why do you need a sql server?
What is subquery in sql?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Write down the syntax and an example for create, rename and delete index?
Mention the differences between local and global temporary tables.
What will you do If the low Performance occurs?
Explain rdbms?
What does null mean?
-
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)
