Hi, The execution plan for a query in oracle 9i shows "Optimizer= CHOOSE", how can i force the DB engine to use the COST based optimization for a query ? Oracle version is 9.2.0.4.0 Thanks Savio Pinto