Tuesday, April 12, 2011

What is denormalization and when would you go for it?





As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Add two integers together
    Module Tester     Sub  Main ()        Dim  firstNumber, secondNumber  As  String        Dim  number1, number2, sumOfNumbers  As  Intege...
  • Turn Explicit off to use variable without declaration
    Option Explicit Off Module Module1      Sub  Main ()          EmployeeName =  "Buddy Jamsa"          EmployeePhoneNumber =  ...
  • Cause compiler error when Option Strict On
    Module Module1         Sub  Main ()      Dim  AnInt  As  Integer =  5      Dim  ALong  As  Long =  7      ALong = AnInt      'ca...