What is denormalization and when would you go for it?
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
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
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain about a primary key?
What is the database development process?
What are the three basic rules which are to be followed for the relational model of the database?
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 what a database is?
In which database can extended stored procedures be added?
Explain about normal forms?
fact table and dimension table containg one to many relationship or many to one relastionship
Explain about the hierarchical model of the database?
In which table collections errors are stored.
Explain about relational database management systems?
State the acid rules?