REORG and RUNSTATS on Insight databases

We're planning on setting up regular REORG and RUNSTATS on our Insight databases, and were wondering whether that would be beneficial, and if so, how often?

Derek, if you're using the BuildStar ETL it runs a REORG on your database, however it's not a smart/efficient REORG... it runs on every table in the database regardless of whether or not we need it. My guess is that is so it can be generic enough to be used regardless of which DBMS is used.

I'd be curious on RUNSTATS though too, or if anyone has done work to make the REORG more efficient and only run on tables that need it.

Derek, if you're using the BuildStar ETL it runs a REORG on your database, however it's not a smart/efficient REORG... it runs on every table in the database regardless of whether or not we need it. My guess is that is so it can be generic enough to be used regardless of which DBMS is used.

I'd be curious on RUNSTATS though too, or if anyone has done work to make the REORG more efficient and only run on tables that need it.

Thanks Jackie. That's good to know.