How often is re-building indexes and gathering statistics required

Hi,

I have written 2 scripts, one that will rebuild all the indexes in the database and second which will analyze database schemas.

my questions are

1) Is it ok to run both is scripts every night. currently i run them once a week. but i am setting them as automated tasks and am wondering that if i run it everyday, will it have any negative impact.

2) is there a general practice of running such scripts in a particular order or is dosnt matter. (eg does it make a diff if i run the analyze schema script first and then the index rebuild script or vice a versa.).

thank you,

severeal comments:

#1 we do rebuild and regenerate stats nightly. my organization is an online enviroment that has many 100's of 1000's of recrods changing daily, so it is required. I would make the decision on wheter to rebuild and regen stats night based upon your needs.

#2 analyze has gone the way of the dodo in 10g. you must use dbms_stats. I will add that in v. 10.1.0.3.0 it is more comprehensive and does a better job than analyze.

~jimbag8