If you are using Rule based optimizer , You don't need to analyze the schema . But if you are using choose / cost based optimizer . You should do that . the frequence is depandent on the transaction volume .