Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39734 Views
- NBP, I also Faced
- E-Mail Answers
Answer Posted / sivaraman (gasc)
Denormalization is the process of attempting to optimize
the performance of a database by adding redundant data or
by grouping data. In some cases, denormalization helps
cover up the inefficiencies inherent in relational database
software. A relational normalized database imposes a heavy
access load over physical storage of data even if it is
well tuned for high performance
| Is This Answer Correct ? | 22 Yes | 5 No |
Post New Answer View All Answers
How to use timestamp datatypes
Which four data types cannot be used as a return type from a user-defined function?
What is DB Development software?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain about relational operator join?
How can you log an error to the server event log from a stored procedure?
What is dbms and its application?
explain detail about ftp in datastage?
What are the types of database model?
What are the constraints on severity level in raiseerror?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain the role of indexing in databases?
How can you fix a poorly performing query?
Explain the cube operator?
