Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Using PQ in FTS

Using PQ in FTS

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Fri, 23 Mar 2007 10:34:22 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C004F81DA7@usa0300ms03.na.xerox.net> 





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


--
http://www.freelists.org/webpage/oracle-l


Received on Fri Mar 23 2007 - 09:34:22 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US