Trace File 10053 to understand the Optimizer (CBO)

The reason to trace the CBO is to understand why the Optimizer made some decisions. In this example we are going to see why same query sometimes uses an index and others it doesn’t, same example was explained HERE It is always useful to have a “GOOD” and “BAD” execution, this way it is easier... » read more