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 ?
nphuongtt_at_yahoo.com (SouthVN) wrote in message news:<ee28214c.0307211957.5f84c40d_at_posting.google.com>...
> 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 !
There is no one correct answer to your unspecific question. How well Oracle performs with a 70 million row table depends on how you access it, the hardware resources available to support it, and the number of concurrent processes that will be going after it.
If the majority of access is single row retrieval by PK then the number of rows will have little practical effect. However, if the majority of queries involve unindexed scans of the full table then how many disks the table is spread over and the number of CPU could be very important because Parallel Query, PQ, would be beneficial in a case like this.
So if all depends on the specifics of how the data is set up and used.
HTH -- Mark D Powell -- Received on Tue Jul 22 2003 - 08:29:40 CDT
![]() |
![]() |