Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many records in a table can run good ?
The Oracle database can handle millions, even billions of rows of data
in one table just fine. It all depends on your hardware (i.e. CPU speed,
RAM, and disk devices), whether you are partitioning such a large table,
and if you optimize your SQL statements to reduce physical reads (and
logical reads too).
HTH,
Brian
SouthVN wrote:
>
> Hi All !
>
> Now I'm using Oracle9i 9.2.0.1.0, with flatform is Window 2000 Pro
> In every table in Oracle, How many records in a table can run good ?
> And Does computer's configuration configure ? to I can get data fast.
> There is a table contains about 70 000 000 records
>
> All Experts Please help me !
> Thanks a lot !
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Tue Jul 22 2003 - 08:21:31 CDT