Re: How many records in a table can run good ?

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 22 Jul 2003 08:13:04 -0700
Message-ID: <3722db.0307220713.6f0eeaac@posting.google.com>

If I had a table with 70 million records, I certainly wouldn't want to be on Windows! Oracle can contain billions of records no problem, but can Windows? For the table to "run good", think of partitioning it, and creating useful indices for when you'll want to retrieve data from it. You can read the Oracle docs at tahiti.oracle.com (you'll need to register, but it's free). You'll find tons of tricks there.

Daniel

> 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 !
Received on Tue Jul 22 2003 - 10:13:04 CDT