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
