Re: ** high water mark for small tables
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 27 Jul 2009 14:11:38 +0300
Message-id: <4A6D8B6A.6040503_at_inter.net.il>
I think that reorg can also change the explain plan from index access to FTS as there are fewer I/O now for FTS.
Date: Mon, 27 Jul 2009 14:11:38 +0300
Message-id: <4A6D8B6A.6040503_at_inter.net.il>
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.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 27 2009 - 06:11:38 CDT