Re: question on SQL queries
Date: 2000/01/11
Message-ID: <947607863.7375.0.pluto.d4ee154e_at_news.demon.nl>#1/1
Within Oracle, this is not possible.
Hth,
It is possible though to use Parallel Query. In this situation you have
multiple CPUs in one system, and you can use them to distribute parts of
your execution paths over different CPUs.
--
Sybrand Bakker, Oracle DBA
Jay Jayaprasad <jayj_at_netscape.net> wrote in message
news:387B4FBC.56F2C386_at_netscape.net...
> I am writing an application where we need to analyze large amounts of
> data. We would like to split up the processing into multiple smaller
> chunks of rows that are executed on different machines. Each machine
> should be able to hook up to the database independently and pick up a
> chunk that is different from one that another machine is getting. One
> approach would be for each machine to independently execute the same
> select query and then for the first machine to process rows 1 to 1000,
> the second machine to process rows 1001 to 2000 etc. This approach would
> work only if it is guaranteed that the same select query that when
> executed at different times on the same data would always return the
> results in the same order. Is this a valid assumption for any Oracle
> server (including parallel server) and any arbitrarily complex select
> query? Also, are there other ways of solving this?
>
> Thanks,
> Jay Jayaprasad
> SPSS Inc.
>
Received on Tue Jan 11 2000 - 00:00:00 CET