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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unnesting Subqueries in an Outline

RE: Unnesting Subqueries in an Outline

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Thu, 23 Aug 2007 14:15:59 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC48242767@LIMENS.sivsa.int> 





Luke,



Ok, thanks. 



What are you using for gathering stats for the table? which
dbms_stats.gather_table_stats (or schema stats) params?



Just for check: have you checked that the outline really contains the
 /*+ NO_UNNEST */ hint?? Which show an "select * from outln.ol$hints " ?



alvaro

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


Received on Thu Aug 23 2007 - 07:15:59 CDT












Original text of this message













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