Denormalized for Performance

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 9 Nov 2005 01:00:11 +0000
Message-ID: <bf46380511081700k47e095b8o607c7ff31f817478@mail.gmail.com>

Sorry for the somewhat off-topic here, but this is really the only place to ask this.

I'm looking for cases where you may have purposely denormalized a table or tables for performance reasons.

Things that come to mind are calculated fields, repeating groups, etc.

If you reply, please supply enough detail so that I can reproduce the table structure. Some idea of the size of the table(s) in number of rows would also be helpful.

If possible, please supply any testing information that made the case for denormalization.

Please reply off-list.

Thank you,

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 08 2005 - 19:02:17 CST