1

Is data redundancy in SQL tables ever acceptable in real world application. Apart from making it easier to query from tables, should one always try to reduce data redundancy?

MetaKnight
  • 31
  • 4
  • https://stackoverflow.com/questions/2349270/in-what-way-does-denormalization-improve-database-performance – Lukasz Szozda Jul 03 '17 at 20:11
  • Possible duplicate of [In what way does denormalization improve database performance?](https://stackoverflow.com/questions/2349270/in-what-way-does-denormalization-improve-database-performance) – Arpit Solanki Jul 03 '17 at 20:12
  • 1
    Of course it is. If it weren't about 80% of real world applications would be out of compliance. However, it needs to be done judiciously, consciously, and for good reasons. – Gordon Linoff Jul 03 '17 at 20:15
  • In order of increasing effort, you can eliminate redundant data, work to keep it all consistent, or fix it after it gets inconsistent. Your database, your time, your choice. – reaanb Jul 03 '17 at 22:13

0 Answers0