This stored procedure should recreate all objects required for the data warehouse to perform efficently, create index that have been dropped before, refresh aggregate tables, rebuild the indexes on the aggregate tables if they have been disabled before, etc. The procedure will return an integer value with the number of problems found, but will never raise an error so that the load can continue.
Overview
Content Tools