Re: ** high water mark for small tables
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.
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.