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"