12-18-2015
2,100,
402
Join Date: Apr 2009
Last Activity: 11 February 2020, 10:24 AM EST
Posts: 2,100
Thanks Given: 26
Thanked 402 Times in 360 Posts
Mathematically, the total number of permutations for joining 9 tables would be 9! or 362880.
However, the parameters - optimizer_max_permutations and optimizer_search_limit are undocumented (deprecated) in Oracle version 10g and higher.
Oracle hasn't mentioned or documented the algorithm it uses to derive the value, so I wouldn't rely too much on that number.
Besides, since they are deprecated: (a) use them at your own risk and (b) Oracle will not provide any support in case you run into problems using them.
Last edited by durden_tyler; 12-18-2015 at 11:47 PM..