[exo-jcr-commits] exo-jcr SVN: r317 - jcr/trunk/component/core/src/main/resources/conf/storage.

Author: pnedonosko Date: 2009-10-20 06:48:00 -0400 (Tue, 20 Oct 2009) New Revision: 317 Modified: jcr/trunk/component/core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql Log: EXOJCR-195: Oracle Analyze script updated Modified: jcr/trunk/component/core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql =================================================================== --- jcr/trunk/component/core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql 2009-10-20 10:31:11 UTC (rev 316) +++ jcr/trunk/component/core/src/main/resources/conf/storage/jcr-sjdbc.ora-analyze.sql 2009-10-20 10:48:00 UTC (rev 317) @@ -19,6 +19,8 @@ CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY(PARENT_ID) REFERENCES JCR_SITEM(ID) ) / +CREATE INDEX JCR_IDX_SITEM_PARENT_FK ON JCR_SITEM(PARENT_ID) +/ CREATE UNIQUE INDEX JCR_IDX_SITEM_PARENT ON JCR_SITEM(CONTAINER_NAME, PARENT_ID, NAME, I_INDEX, I_CLASS, VERSION DESC) / CREATE UNIQUE INDEX JCR_IDX_SITEM_PARENT_NAME ON JCR_SITEM(I_CLASS, CONTAINER_NAME, PARENT_ID, NAME, I_INDEX, VERSION DESC) @@ -58,22 +60,14 @@ ANALYZE INDEX JCR_PK_SITEM COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_SITEM_ID COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_SITEM_PARENT_FK COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_SITEM_PATH COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_SITEM_PARENT COMPUTE STATISTICS / -ANALYZE INDEX JCR_PK_SNODE COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_SITEM_PARENT_NAME COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_SNODE_PARENT COMPUTE STATISTICS +ANALYZE INDEX JCR_IDX_SITEM_PARENT_ID COMPUTE STATISTICS / -ANALYZE INDEX JCR_IDX_SNODE_PARENTID COMPUTE STATISTICS -/ -ANALYZE INDEX JCR_PK_SPROPERTY COMPUTE STATISTICS -/ -ANALYZE INDEX JCR_IDX_SPROPERTY_PARENT COMPUTE STATISTICS -/ -ANALYZE INDEX JCR_IDX_SPROPERTY_PARENTID COMPUTE STATISTICS -/ ANALYZE INDEX JCR_PK_SVALUE COMPUTE STATISTICS / ANALYZE INDEX JCR_IDX_SVALUE_PROPERTY COMPUTE STATISTICS @@ -81,4 +75,6 @@ ANALYZE INDEX JCR_PK_SREF COMPUTE STATISTICS / ANALYZE INDEX JCR_IDX_SREF_PROPERTY COMPUTE STATISTICS -/ \ No newline at end of file +/ +ANALYZE INDEX JCR_PK_SCONTAINER COMPUTE STATISTICS +/