RE: Unnesting Subqueries in an Outline
- From: "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
- To: <luke.davies@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Aug 2007 14:15:59 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
