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.
- 3 Answers
- 24684 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
why DEPB Licence application is doing
which companies in nifty
tell me abt ur most memorable moment
I Need Apsrtc Traffic Supervisor Medal Paper.. Please send me any one.....gasiganti@gmail.com
why u have choosen finance has a specialisation
please send me ubi model papers to my email idsssss anil0001_mca@yahoo.co.in , ravi_kumar3713@yahoo.com thankuuuuuuu
* i completed gratuation BBA but i passed 50% marks and i will give bank exam its valiad for bank
IS ANYONE FROM GUJARAT RECEIVED JOINING LETTER OF BOB CLERK 2011 , KINDLY POST IT or CONTACT BY EMAIL. sinhasanjiv73@gmail.com
what is your team size
