Re: large table optimizer suggestions

From: <fitzjarrell_at_cox.net>
Date: 24 Aug 2005 13:47:42 -0700
Message-ID: <1124916462.479695.273780@f14g2000cwb.googlegroups.com>

mark thomas wrote:
> > 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.

You are, apparently, new to this group. People attempt to do the strangest things to save a little money. Then they come here and ask what could possibly be wrong.

David Fitzjarrell Received on Wed Aug 24 2005 - 15:47:42 CDT