Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Don't store values that can be derived

Eslam_ElbyalyJul 26 2018 — edited Apr 7 2020

HI,

one of Codd's 12 rules says that. But I think the reason behind it was that it was considered a storage overload. I believe that was right in the 70th but now I think storage is not an issue. So Why would I write code to calculate values when I can store them directly which will also have a positive impact on performance?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2018
Added on Jul 26 2018
37 comments
2,141 views