Re: Oracle Table Spanning

Hi,

you can have several hundred million rows without problems.

I run such tables.

Make shure your indexes are well chosen.

a date column is very helpful.

statemants like:

select ... where mydate between '1.1.2004' and '31.1.2004'

should perform very well.

for fast handling, creating a smaller extract of your table and using this is often a faster solution.

With other words: Use partitioning only where absolut necessary. I strongly believe you do not have to use partitioning.

HTH, Toni

In article <fPWdnc_DQtjETIzdRVn-hw_at_adelphia.com>, OpticTygre <optictygre_at_adelphia.net> wrote:

> Hi folks. Does anyone know where I can find any good resources on how to do
> table spanning in Oracle? I have some very large tables which holds data
> reports that come off thousands of machines on a monthly basis. These
> reports are unrelational, and very user-unfriendly, and unfortunately, I'm
> not allowed to manipulate the data. After a short time, there will be
> millions and millions of rows for each of these reports. Is there a way I
> could span the data across multiple tables without interfering too much with
> outside code (ASP) that accesses the database? Is there a better way to
> handle this problem?
>
> If anyone could point me in the right direction, it would be greatly
> appreciated. Thanks in advance.
>
> - J
>
>
Received on Mon Jan 26 2004 - 07:42:02 CST