jive_oracle_8_analyze.sql

Struts+Spring+Hibernate开发的BBS,功能很强大很完善

REM  //////////////////////////////
REM  // $RCSfile: Jive_oracle_8_analyze.sql,v $
REM  // $Revision: 1.1.1.1 $
REM  // $Date: 2002/09/09 13:50:34 $
REM  //////////////////////////////

analyze table jiveForum compute statistics for all indexes;
analyze table jiveForum compute statistics for table;

analyze table jiveForumProp compute statistics for all indexes;
analyze table jiveForumProp compute statistics for table;

analyze table jiveThread compute statistics for all indexes;
analyze table jiveThread compute statistics for table;

analyze table jiveThreadProp compute statistics for all indexes;
analyze table jiveThreadProp compute statistics for table;

analyze table jiveMessage compute statistics for all indexes;
analyze table jiveMessage compute statistics for table;

analyze table jiveMessageProp compute statistics for all indexes;
analyze table jiveMessageProp compute statistics for table;

analyze table jiveUser compute statistics for all indexes;
analyze table jiveUser compute statistics for table;

analyze table jiveUserPerm compute statistics for all indexes;
analyze table jiveUserPerm compute statistics for table;

analyze table jiveUserProp compute statistics for all indexes;
analyze table jiveUserProp compute statistics for table;

analyze table jiveGroup compute statistics for all indexes;
analyze table jiveGroup compute statistics for table;

analyze table jiveGroupPerm compute statistics for all indexes;
analyze table jiveGroupPerm compute statistics for table;

analyze table jiveGroupProp compute statistics for all indexes;
analyze table jiveGroupProp compute statistics for table;

analyze table jiveID compute statistics for table;

analyze table jiveModeration compute statistics for all indexes;
analyze table jiveModeration compute statistics for table;

analyze table jiveWatch compute statistics for all indexes;
analyze table jiveWatch compute statistics for table;

analyze table jiveReward compute statistics for all indexes;
analyze table jiveReward compute statistics for table;