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