Actually, even Microsoft SQL Server will do this for you (you can even chose if it shoudl split it up on all processors or a maximum number). Will do it on any types of queries, as long as they're big enough (you can tweak the cost limit, but the general idea is only process CPU-expensive queries that way)
//Magnus > -----Original Message----- > From: Andriy Tkachuk [mailto:[EMAIL PROTECTED] > Sent: Monday, October 13, 2003 10:53 AM > To: Bill Moran > Cc: johnnnnnn; [EMAIL PROTECTED] > Subject: Re: [PERFORM] One or more processor ? > > > On Fri, 10 Oct 2003, Bill Moran wrote: > > > johnnnnnn wrote: > > > On Fri, Oct 10, 2003 at 12:42:04PM -0400, Bill Moran wrote: > > > > > >>4) It simply isn't practical to expect a single query to > > >> execute on multiple processors simultaneously. > > >> > > >>Do you know of any RDBMS that actually will execute a > single query > > >>on multiple processors? > > > > > > Yes, DB2 will do this if configured correctly. It's very > useful for > > > large, complicated queries that have multiple subplans. > > > > I expected there would be someone who did (although I > didn't know for > > sure). > > > > Is DB2 the only one that can do that? > > Oracle, i think, on partitioned tables. > > regards, andriy > http://www.imt.com.ua ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
