RE: Fun with the CARDINALITY and DYNAMIC_SAMPLING hint
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Fri, 14 Sep 2012 14:59:20 +0000
Message-ID: <DUB115-W17FC2FC7CCBB7F81B8EB48A1900_at_phx.gbl>
Date: Fri, 14 Sep 2012 14:59:20 +0000
Message-ID: <DUB115-W17FC2FC7CCBB7F81B8EB48A1900_at_phx.gbl>
I didn't know you could use cardinality to hint join cardinalities - the downside of undocumented hints?
I can think of several cases before opt_estimate came along where I might have made use of that (as a last resort).
Probably for the best...
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 14 2012 - 09:59:20 CDT