Re: handling large tables in oracle 8

Look at partitioned tables. You can either treat the whole thing as one table, or hit the partitions individually. They will do exactly what you want to do below.

Max number of records in Oracle is massive, but your performance will be based on how many rows you want to return. 1,000,000 rows. Is that slow or fast? Depends on your hardware and how you've configured it. There is not easy answer. If you are considering a VLDB (say, 1TB or larger) you'll need some serious hardware and configuration skills. Most vendors (in my experience) will offer test facilities and consultancy up-front, as well as performance specs. (after all, they want your business).

MotoX.

Neeraj Mital wrote in message <6mavgu$k7f_at_svna0001.clipper.ssb.com>...
>Hello folks,
>
>I have a large table, which I want to split into many tables all stored on
>the same database. All the tables will be identical except that each will
>contain different set of records based on some keys. Does oracle 8 provide
>any support for this.
>
>This seems to be similar to horizontal partitioning, except that in
>horizontal partitioning, the different tables are stored in different
>instances of the database, in my case all tables will be identical, have
>different names, stored on same database, and contain records based on
>certain keys.
>
>Another related question is - have you come across apps where this has
 been.
>What were the benefits of doing it.
>
>Do you know any limits on the number of records in Oracle 8, after which
>system does not behave properly or the queries (even indexed) become slow.
>
>Any help appreciated.
>
>thanks
>
>neeraj
>neeraj_at_tiac.net
>
>
>
Received on Thu Jun 18 1998 - 00:00:00 CEST