Is that a good idea to gather statistic for entire schema or only table ,index and cluster . How often we will gather the statistic of all table. Is that weekly will be good ?
Thanks in advance