Re: What is Parallel DML?

Search by rowid range does work - however you may need the hint /*+ rowid (t) */. See my website on the topic of 'miscellaneous -> Big Update' for an example related to your topic of home-grown pq.

BTW - 8.1.7 stopped doing the

    rowid between :b1 and :b2
it has now introduced a

    px_granule()
function into the query where clause
to indicate the row selection method.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Galen Boyer wrote in message ...


>On Sat, 21 Jul 2001, vslabs_at_onwe.co.za wrote:

>

>> Oracle now uses 50 process for the query. The big table is

>> broben up into 50 chunks - Oracle modifies your SQL query

>> slightly and add a WHERE clause to it. WHERE rowid BETWEEN :a

>> AND :b

>

>This would fail if I tried to do it myself.  A BETWEEN is

>effectively < x and > y and the > y for rowid will fail to find

>rows.  But I'm sure Oracle knows how to do it.

>

>How could we mimic PQ by splitting up the query ourselves into 50

>different queries and then running them all at the same time?

>Could this be done and get the pretty much the same result that

>Oracle does (Disregarding the final count, just get fifty

>answers)?

>

>--

>Galen Boyer

>It seems to me, I remember every single thing I know.

>