Re: Oracle Table Spanning

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)