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

Home -> Community -> Usenet -> c.d.o.server -> merging small tables

merging small tables

From: Stjepan Brbot <stjepan.brbot_at_zg.hinet.hr>
Date: Sat, 3 Aug 2002 00:02:47 +0200
Message-ID: <aifov3$3c8u$3@as201.hinet.hr> 





I have a lot of small tables of type [no,itemname] having few (3-10)
records and those tables will never be bigger! Regarding the performance
and rationality of using DB space, is it better to create a new table of
type [domain,no,itemname] and merge all records from small tables and
distinguishing them by domain?


--

Stjepan Brbot


Received on Fri Aug 02 2002 - 17:02:47 CDT












Original text of this message













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