Questions about PQO ...
From: <agi_at_mail.taicom.com.tw>
Date: Fri, 28 May 1999 11:58:54 GMT
Message-ID: <7im0dt$dd7$1_at_nnrp1.deja.com>
Hi,theres,
Date: Fri, 28 May 1999 11:58:54 GMT
Message-ID: <7im0dt$dd7$1_at_nnrp1.deja.com>
Hi,theres,
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 !!
Rgds,
Agi Chen
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri May 28 1999 - 13:58:54 CEST