RE: Fun with the CARDINALITY and DYNAMIC_SAMPLING hint

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Fri, 14 Sep 2012 13:52:12 +0000
Message-ID: <DUB115-W790D0CF5B906D50843D307A1900_at_phx.gbl>

Cardinality hints and dynamic sampling only affect single table cardinality estimates so using both for a single table doesn't make sense.

If you want to influence join estimates something like OPT_ESTIMATE is much more flexible, but undocumented.                                                

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

Received on Fri Sep 14 2012 - 08:52:12 CDT