Re: ** high water mark for small tables

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Mon, 27 Jul 2009 14:11:38 +0300

I think that reorg can also change the explain plan from index access to FTS as there are fewer I/O now for FTS. 


Adar Yechiel
Rechovot, Israel



Ric Van Dyke wrote:


Hi Joshi,
Any table that that occupies fewer blocks after a rebuild type operation will have improved performance for a full table scan since fewer blocks have to read for the full table scan.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2009