Re: ** high water mark for small tables

From: Yechiel Adar <>
Date: Mon, 27 Jul 2009 14:11:38 +0300
Message-id: <>

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.

Received on Mon Jul 27 2009 - 06:11:38 CDT

Original text of this message