Optimizer Features Enable

Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams158.htm

Optimizer Features for Oracle9I Releases

Features 9.0.0 9.0.1 9.2.0
Index fast full scan X X X
Consideration of bitmap access to paths for tables with only B-tree indexes X X X
Complex view merging X X X
Peeking into user-defined bind variables X X X
Index joins X X X

Optimizer Features for Oracle Database 10g Releases

Features 10.1.0 10.1.0.3 10.1.0.4 10.1.0.5 10.2.0.1 10.2.0.2
Index fast full scan X X X X X X
Consideration of bitmap access to paths for tables with only B-tree indexes X X X X X X
Complex view merging X X X X X X
Peeking into user-defined bind variables X X X X X X
Index joins X X X X X X
Dynamic sampling X X X X X X
Query rewrite enables X X X X X X
Skip unusable indexes X X X X X X
Automatically compute index statistics as part of creation X X X X X X
Cost-based query transformations X X X X X X
Allow rewrites with multiple MVs and/or base tables X X

Optimizer Features for Oracle Database 11g Releases

Features 11.1.0.6
Enhanced Bind Peeking X
Use extended statistics to estimate selectivity X
Use native implementation for full outer joins X
Partition pruning using join filtering X
Group by placement optimization X
Null aware antijoins X