Oracle Optimizer Cost Based TransformationsJoin View FactorizationRecently, I got a complain regarding slowness in the Db where one of the query was spending lot of time and its was like never ending.Looking at it closely it was Optimizer cost based transformation which was doing the trick.Optimizer Cost based transformation<Default value Linear> is the one which allows Oracle Optimizer to
Vineet’s Oracle Blog Spot