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 -> Performance problems with really big tables

Performance problems with really big tables

From: Marco Ribeiro <mar_at_bart.inescn.pt>
Date: Mon, 14 Dec 1998 13:44:53 +0000
Message-ID: <36751654.26697826@bart.inescn.pt> 





Hi,



We've got two tables with more than 6 million records in each one and
performance deteriorates as they grow, can anyone give some advice on
improving the performance of operations on these tables.



Also is it more eficient to have a surrogate key or a compund key ?



Thanks,



Marco Ribeiro

Received on Mon Dec 14 1998 - 07:44:53 CST












Original text of this message













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