ifyoupgradeyourdatabasefromrelease 10.1 to release 11.1,butyouwanttokeeptherelease 10.2.0.4 optimizer behavior, youcandosobysettingthisparameterto 10.2.0.4.atalatertime,youcantrytheenhancementsintroducedinreleasesuptoandincluding
属性描述符参数属性
syntax optimizer _ features _ enable={8.0.0|8.0.4|8.0.5|8.0.6|8.0.7|8.0.1. 1
Default value11.1.0.7
table1-3optimizerfeaturesfororacle9ireleasesfeatures 9.0.09.0.19.2.0 indexfastfullscanxxx
considerationofbitmapaccesstopathsfortableswithonlyb-treeindexesxxx
Complex view mergingXXX
peekingintouser-definedbindvariablesxxx
索引joins XXX
table1-4optimizerfeaturesfororacledatabase 10.1.010.1.0.310.1.0.410.1.0.0.0.0.0
considerationofbitmapaccesstopathsfortableswithonlyb-treeindexesxxxxxx
Complex view mergingXXXXXX
peekingintouser-definedbindvariablesxxxxxxx
索引joins xxxxxxx
动态范例XXXXXX
查询重新启用XXXXXX
Skip unusable indexesXXXXXX
自动计算xxxxxxx
成本- basedquerytransformationsxxxxx
allowrewriteswithmultiplemvsand/orbasetablesxx
table1-5optimizerfeaturesfororacledatabase 11 greleasesfeatures 11.1.0.6 enhancedbindcrdpd/puseextendedstatisticstoesticsticstoestoestimimime
usenativeimplementationforfullouterjoinsx
partitionpruningusingjoinfilteringx
组按位置优化x
空值助手