Questions about PQO ...

From: <>
Date: Fri, 28 May 1999 11:58:54 GMT
Message-ID: <7im0dt$dd7$>


   Our DB(8.0.5 With the Partitioning, Objects and Parallel Server options, 2 nodes(RS/6000))is on AIX.

   I have some problems about Parallel Querry Option,    1.Does PQO operate for single INSERT, UPDATE, DELETE statements      ( without any subquery ) ??
   2.At what situation(and under what condition), I can use PQO to get      better performance ?
    (What's the relations between DML(DDL) statements and partitioning)?

   Thanks for any suggestions !!
[Quoted]    Or someone can show me some papers/sites about PQO , thanks !!

Agi Chen

Sent via
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 13:58:54 CEST

Original text of this message