Dear Daniel, there IS occurence when partitioning would not help - when all
data at once is requered. You can partition table infinitely correct, but
this would not help. As original poster noted, he can not change database
and application design, so you helpfull comments are useless at this given
case. It's seems like database optimization question, and not so easily
answerable.
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1074927975.732299_at_yasure...
> OpticTygre wrote:
> > Actually, I'm not sure the solution. Hence the reason I'm checking into
> > possibilities. Oracle version is 9i. And when I say millions and
millions,
> > I don't just mean 5 million rows per month. More like 100-150 million
per
> > month. Which adds up quickly.
>
> Then you should be thinking Enterprise Edition and use partitioning. I
> have no idea what you are thinking when you say "table spanning" but if
> it isn't partitioning then you are likely chasing a bad concept.
>
> To better understand partitioning go to: http://tahiti.oracle.com
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Sat Jan 24 2004 - 03:35:26 CST
