Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: large table optimizer suggestions
> Tests I conducted in the pasts demonstrated, that if you
> don't have your table striped or partitioned across
> multiple disks, parallel query is pretty useless.
Yes, of course. Sorry my statement there was a bit too loose. I assumed it was implied that I have multiple disks, since there would be no expected gain otherwise. It also never occurred to me that anyone would expect that a 4,000,000,000 row table would reside on one disk. Received on Wed Aug 24 2005 - 14:35:26 CDT