Using PQ in FTS

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 23 Mar 2007 10:34:22 -0400

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


Other related posts: