Oracle Database Discussions

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!

Normalization vs Denormalization

156721Sep 7 2005 — edited Sep 8 2005

I have a order transaction table as subitem level.
The table order_subitem is 30 column table with 300 million rows and is about 60 GB is size.
The table has been denormalized with item and order level attributes.
Will breaking the table in to 4 tables (normalizing) and then creating a view for the user help in terms of user query performance ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2005

Added on Sep 7 2005

#general-database-discussions

3 comments

539 views