> I would think ideal is "as fast as possible" and assuming you tell> Oracle the truth about speed of multiblock reads verse single block with> optimizer_index_cost_adj everything should work out fine, even if full> scans are favored. Of course too many scans at the same time and> optimizer_index_cost_adj is no longer valid because IO bandwidth may> effect response times, so I guess this is where system stats has a> supreme advantage.> >