Re: One or more processor ?

On Mon, 2003-10-13 at 01:53, Andriy Tkachuk wrote:
> > >>Do you know of any RDBMS that actually will execute a single query
> > >>on multiple processors?
> > >
> Oracle, i think, on partitioned tables.

This makes a certain amount of sense. It be much easier to allow this
on partitioned tables than in the general case, since partitioned tables
look a lot like multiple relations hiding behind a view and one could
simply run one thread per partition in parallel without any real fear of
contention on the table. This is doubly useful since partitioned tables
tend to be huge almost by definition.

Offhand, it would seem that this would be a feature largely restricted
to threaded database kernels for a couple different pragmatic reasons.

Cheers,

-James Rogers
jamesr(at)best(dot)com