Re: Large tables
From: Gary Eckhardt <dcigary_at_tcp.co.uk>
Date: 1995/12/26
Message-ID: <4bp4hv$j7h_at_nimitz.fibr.net>#1/1
Date: 1995/12/26
Message-ID: <4bp4hv$j7h_at_nimitz.fibr.net>#1/1
Tom Gillespie (tgillesp_at_ms13.mis.semi.harris.com) wrote:
: This is true, but as I understand it, extents are also limited to 2GB,
: so if you want to keep your table in one extent, like ORACLE recommends
: for performance reasons, your table is effectively limited to 2GB,
: right ?
I've created tables as large as 10GB using the multiple datafile method, and havent run across any huge impact on performance. Just make sure that the datafiles are separated as much as possible across physical disk devices.
---------------------------+---------------------------------------------- Gary Eckhardt | "in this day & age...music performed by Database Consultants, Inc. | humans...hum!?" --wilde silas tomkyn dcigary_at_txdirect.net | gary_eckhardt_at_realworld.com| R^3 = "Real World. Real Smart. Real Quick." (210)344-6566 | http://www.realworld.com/Received on Tue Dec 26 1995 - 00:00:00 CET