Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 38948 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
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?
What is an application role and explain a scenario when you would use one?
How long can an error message be in raiseerror function?
Who are naive users?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How you can make a parameterized view?
How can I detect whether a given connection is blocked?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain about the hierarchical model of the database?
Explain what a database is?
How to replace not in with not exist?
How to read and create .LDC data files which are used by linguatic dictionary.
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Explain the rollup operator?
