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
- 24571 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 are certificate of deposits?
I Need Apsrtc Traffic Supervisor Medal Paper.. Please send me any one.....gasiganti@gmail.com
What is different meaning of pre-advice and pay order to the benificiary.
ROLES AND RESPONSIBILITIES OF A BUSINESS MIS MANAGER(NON IT)?
i have secured my graduation with very low %age of 48% and with two attempts but in mba entrance i have secured 91%ile so im afraid abt interview that if they ask me about my academics and y i have such low performance how will i face that with confidence plz answer this .
What all document does a Business Analyst prepare?
what is the exact meaning for businessgroup,set of books,legal entity,operating unit,inventory organization?
how will you motivate your workers to strive willingly in a target based industry
WHAT IS ASSESSMENT?
What worked well and what didn't?
How successful were you and how do you know that?
Depresation Rates as per Income Tax Law ?
pvt.ltd. has furnished the following aanual budgets at 60% and 80% levels of activity: level of capacity 600units 800units direct material 360000 480000 direct labour 480000 640000 production overhead 252000 276000 administration overhead 124000 132000 s.& d.overhead 136000 148000 calculate the total cost at 75% level of activity working should be part of your answer
what is the difference between share and debenture?
what are the main difference between saving with a bank and with insurance company.
