Re: Oracle CBO question
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- Date: Thu, 7 Jun 2007 14:05:03 -0700
On 6/7/07, K Gopalakrishnan <kaygopal@xxxxxxxxx> wrote:
Jared,
N factorial permutations for N tables are theoretical limit. However
in practice the number of combinations are optimized (read: limited)
to a much smaller number than the thousands. If you start examining
all the thousands of combinations the parse time itself will run for
minutes and to avoid that there are limits defined for everywhere.
Yes, that was my point.
There is an 'optimizer_search_limit' and also
'_new_initial_join_orders' limits the number of permutations .
Thanks.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
