dbms_stats.delete_column_stats(..., col_stat_type=>'HISTOGRAM'); If on 10.2.0.3/4 then apply patch 5579764 first. http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_stats.htm#sthref8257 On Sun, Oct 24, 2010 at 11:24 AM, Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx> wrote: > instead > set only min/max value . > So, I need kind of 'for all columns size 1' but without rerunning > dbms_stats.gather_... . > Regards. > Greg > X-archive-position: 31902 > X-ecartis-version: Ecartis v1.0.0 > Sender: oracle-l-bounce@xxxxxxxxxxxxx > Errors-to: oracle-l-bounce@xxxxxxxxxxxxx > X-original-sender: grzegorzof@xxxxxxxxxx > Precedence: normal > Reply-To: grzegorzof@xxxxxxxxxx > List-help: <mailto:ecartis@xxxxxxxxxxxxx?Subject=help> > List-unsubscribe: <oracle-l-request@xxxxxxxxxxxxx?Subject=unsubscribe> > List-software: Ecartis version 1.0.0 > List-Id: oracle-l <oracle-l.freelists.org> > X-List-ID: oracle-l <oracle-l.freelists.org> > List-subscribe: <oracle-l-request@xxxxxxxxxxxxx?Subject=subscribe> > List-owner: <mailto:steve.adams@xxxxxxxxxxxx> > List-post: <mailto:oracle-l@xxxxxxxxxxxxx> > List-archive: <//www.freelists.org/archives/oracle-l> > X-list: oracle-l > > > > ---------------------------------------------------------------- > Zobacz ile kosztuje m2 w Twoim miescie. Szukaj w bazie ogloszen! > http://linkint.pl/f281f > > -- > //www.freelists.org/webpage/oracle-l > > > -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l