Re: Managing tables with >800 fields

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 5 Jun 2001 20:53:54 +0200
Message-ID: <thqai0kmkush51@beta-news.demon.nl>

"Tom Lewis" <lewis_uk_at_hotmail.com> wrote in message news:6d8d2ec4.0106050514.62eb8bdd_at_posting.google.com...
> I have an operational data store with 10 million records in an account
> table and 500 million records in a transactional table. The account
> table is >800 fields wide but only c30 of these are frequenetly used.
>
> Is it worthwhile to split the 800 field table into one of 35 fields
> and one of 765 fields and if so, what is the most effective way to
> join they back together?
>
> Tom

I'm almost sure we have an issue of shitty database design here, and no normalization has been in place.
I would normalize the design first, before I start to proceed further on the path to hell.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jun 05 2001 - 13:53:54 CDT