Thx Pando , just wondering people are experiencing any issues with 8173 Optimizer. This Release had given me query performance issues always. None of the methods of statistics gathering helped me before and now. Repeating cycles of tuning exercise helped me, which tables to have statistics and which tables not to have statistics for optimal performance of queries on 200 + million row range partitioned tables. Finally 8174 Solved most of the issues.