Author: tolusha Date: 2011-12-26 09:21:05 -0500 (Mon, 26 Dec 2011) New Revision: 5358 Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.ora-analyze.sql jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql Log: EXOJCR-1511: fixed scripts for oracle Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.ora-analyze.sql =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.ora-analyze.sql 2011-12-26 13:49:42 UTC (rev 5357) +++ jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.ora-analyze.sql 2011-12-26 14:21:05 UTC (rev 5358) @@ -64,24 +64,20 @@ -ANALYZE INDEX JCR_PK_SITEM COMPUTE STATISTICS +ANALYZE INDEX JCR_PK_MITEM COMPUTE STATISTICS / ANALYZE INDEX JCR_IDX_MITEM_ID COMPUTE STATISTICS / ANALYZE INDEX JCR_IDX_MITEM_PATH COMPUTE STATISTICS / -ANALYZE INDEX JCR_PK_MNODE COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_MITEM_PARENT COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_MNODE_PARENT COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_MITEM_N_ORDER_NUM COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_MNODE_PARENTID COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_MITEM_PARENTID COMPUTE STATISTICS / -ANALYZE INDEX JCR_PK_MPROPERTY COMPUTE STATISTICS +ANALYZE INDEX JCR_PK_MITEM COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_MPROPERTY_PARENT COMPUTE STATISTICS -/ -ANALYZE INDEX JCR_IDX_MPROPERTY_PARENTID COMPUTE STATISTICS -/ ANALYZE INDEX JCR_PK_MVALUE COMPUTE STATISTICS / ANALYZE INDEX JCR_IDX_MVALUE_PROPERTY COMPUTE STATISTICS Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql 2011-12-26 13:49:42 UTC (rev 5357) +++ jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql 2011-12-26 14:21:05 UTC (rev 5358) @@ -66,6 +66,8 @@ / ANALYZE INDEX JCR_IDX_SITEM_PARENT COMPUTE STATISTICS / +ANALYZE INDEX JCR_IDX_SITEM_N_ORDER_NUM COMPUTE STATISTICS +/ ANALYZE INDEX JCR_IDX_SITEM_PARENT_NAME COMPUTE STATISTICS / ANALYZE INDEX JCR_IDX_SITEM_PARENT_ID COMPUTE STATISTICS