Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Managing tables with >800 fields

Managing tables with >800 fields

From: Tom Lewis <lewis_uk_at_hotmail.com>
Date: 5 Jun 2001 06:14:05 -0700
Message-ID: <6d8d2ec4.0106050514.62eb8bdd@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
Received on Tue Jun 05 2001 - 08:14:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US