Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between normalization and
denormalization.
in normalization all tables are normalizad format or not.
what r the types of indexes are there.
what is difference b/w bitmap,b-tree,unique and function
based indexes.
- 2 Answers
- 24456 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / samarth
Denormalization is the process of introducing redundancy
into a table by incorporating data from a related table.
Tables are usually denormalized to prevent expensive SQL
join operations between them.
One should always normalize to third-normal form and only
apply denormalization selectively as a last resort if
performance problems are experienced. Remember that
denormalizations is not free and introduces the following
problem into the design:
More disk space is used as the same data is duplicated in
more than one table
DML operations are more expensive as the same data must be
maintained in more than one table
You run the risk that the data can get "out of sync"
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
what is the exact meaning for businessgroup,set of books,legal entity,operating unit,inventory organization?
what are the benefits of insurance as compared to banking
Dear All,I'm selected in SBI Management Exceutive exam, please send me some model questions generally asked in interview.Thanks.my email id amitroy2001@gmail.com
What is equity share suspense?
SAP SD. What are the Condition Conversion and Customer/Material conversion in the Organization Structure and should define and assign? Please nevigate and explain with example.
‘Fixed Price’ and ‘Cost Plus’ contracts
Sir when will the SBI Associate bank PO Exams results will be released .which the the exam held on 7 th Aug 2011.
what is the basic deference between mission and vision?
What is the difference between Bank rate and Repo rate?
How do you balance the need for quality work, customer satisfaction and profitability?
please give information about Aviation Management course
sir what is c from . cst no is only c from?
what do we see as our primary and secondary roles within a company?
WHY DID U WANT TO JOIN US(Management Technology Consultant)?
What all MLM Company is required to SEBI Registration for Business. What The SEBI takes Action at MLM Company. IF Yes Then How ?
