Re: why people delete statistics bore running statistics

From: Gilles Hamel <hamelg_at_laposte.net>
Date: Mon, 23 Oct 2006 20:51:22 +0200
Message-ID: <453d0f2a$0$27403$ba4acef3@news.orange.fr>

Hello,

At metalink, I found a script to gather statistics on 11i ebusiness suite :

Subject: *coe_stats.sql - Automates CBO Stats Gathering using FND_STATS and Table sizes*
Doc ID </help/usaeng/Search/search.html#file>: *Note:156968.1*

foreach tables, the script does :

EXEC DBMS_STATS.DELETE_TABLE_STATS(ownname => 'x', tabname => 'TABLE'); ANALYZE TABLE x.TABLE ESTIMATE STATISTICS SAMPLE 1 ROWS; EXEC FND_STATS.GATHER_TABLE_STATS(ownname=>'x',tabname=>'TABLE', ...);

I think there would be a valid raison to do that. Why the analyze statement before the gather_table_stats ?

Thank you Received on Mon Oct 23 2006 - 13:51:22 CDT