Dear Friends, We allready know Normalization is the process to optimize the storage and increase the performance of system by eliminating redundancy from database. But there is also circumstances when Normalization can reduce database performance.Due to Joins-Jonis-Joins system makes complex to select a simple record-set. A normalized database requires much more CPU , memory , and I/O to process transactions and database queries than does a normalization database. Ref: 1.) advantages-disadvantages-normalizing-database 2.) www.informit.com/articles
Connecting, Sharing and Discovering