No, PQ used by batch jobs. ________________________________ From: Arul Ramachandran [mailto:contactarul@xxxxxxxxx] Sent: Monday, March 26, 2007 1:08 PM To: Hameed, Amir Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Using PQ in FTS I was going to say unintended block cleanouts.. but then glanced Jonathan Lewis' book page 30 where it mentions 'segment checkpoint', that sounds almost like block cleanouts.... I suppose you did not mean PQ will be used by OLTP queries... Arul On 3/23/07, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote: Folks, If there are statements where FTS on large tables is unavoidable due to the logic in the statements, is there a downside of using PQ to scan those tables? Jonathan has mentioned one caution on page 30 of his book but are there any other issues that one must be aware of ? The RDBMS version are 9.2.0.6 and 10.2.0.2. Thanks Amir -- //www.freelists.org/webpage/oracle-l -- Arul