when should be the statistics collected ?

Some greate guide lines to collect statistics
All non unique indices
Non index join columns
Primary index of small tables
Secondary indexs mentained in the tables