collect stats prob

Database
N/A

collect stats prob

Hi,

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

Re: collect stats prob

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%