All Forums Database
Grao 48 posts Joined 08/06
27 Nov 2007
collect stats prob

Hi,Is there any performance improvement if statistics is collected first and then the table is populated?i.ecreate table a(col1 int,col2 char(4) ....);collect stats on a column (col1);THEN

nithyanandam 65 posts Joined 10/04
28 Nov 2007

I'm not sure if the statistics to an empty table would mean anything to the optimizer. Always try to collect stats after the data load. And, as others have suggested in your other post, recollect stats, if there is a load change of 10%

You must sign in to leave a comment.