Repository: syncope Updated Branches: refs/heads/2_0_X ae2512acc -> 4120fe3f0
missing very important indexes Project: http://git-wip-us.apache.org/repos/asf/syncope/repo Commit: http://git-wip-us.apache.org/repos/asf/syncope/commit/4120fe3f Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/4120fe3f Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/4120fe3f Branch: refs/heads/2_0_X Commit: 4120fe3f023f8b38143913a33a4301e869680624 Parents: ae2512a Author: fmartelli <fabio.marte...@gmail.com> Authored: Mon Jun 19 14:44:56 2017 +0200 Committer: fmartelli <fabio.marte...@gmail.com> Committed: Mon Jun 19 14:44:56 2017 +0200 ---------------------------------------------------------------------- .../src/main/resources/indexes.xml | 23 +++++++++++++++++--- 1 file changed, 20 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/syncope/blob/4120fe3f/core/persistence-jpa/src/main/resources/indexes.xml ---------------------------------------------------------------------- diff --git a/core/persistence-jpa/src/main/resources/indexes.xml b/core/persistence-jpa/src/main/resources/indexes.xml index ded4d52..c9b51a5 100644 --- a/core/persistence-jpa/src/main/resources/indexes.xml +++ b/core/persistence-jpa/src/main/resources/indexes.xml @@ -67,13 +67,30 @@ under the License. <entry key="ARelationship_AnyObjectIndex">CREATE INDEX ARelationship_AnyObjectIndex ON ARelationship(left_anyObject_id)</entry> <entry key="UPlainAttrValue_attrIndex">CREATE INDEX UPlainAttrValue_attrIndex on UPlainAttrValue(attribute_id)</entry> + <entry key="UPlainAttrUniqueValue_attrIndex">CREATE INDEX UPlainAttrUniqueValue_attrIndex on UPlainAttrUniqueValue(attribute_id)</entry> + <entry key="GPlainAttrValue_attrIndex">CREATE INDEX GPlainAttrValue_attrIndex on GPlainAttrValue(attribute_id)</entry> + <entry key="GPlainAttrUniquesValue_attrIndex">CREATE INDEX GPlainAttrUniqueValue_attrIndex on GPlainAttrUniqueValue(attribute_id)</entry> + <entry key="APlainAttrValue_attrIndex">CREATE INDEX APlainAttrValue_attrIndex on APlainAttrValue(attribute_id)</entry> + <entry key="APlainAttrUniqueValue_attrIndex">CREATE INDEX APlainAttrUniqueValue_attrIndex on APlainAttrUniqueValue(attribute_id)</entry> + <entry key="CPlainAttrValue_attrIndex">CREATE INDEX CPlainAttrValue_attrIndex on CPlainAttrValue(attribute_id)</entry> + <entry key="CPlainAttrUniqueValue_attrIndex">CREATE INDEX CPlainAttrUniqueValue_attrIndex on CPlainAttrUniqueValue(attribute_id)</entry> + + <entry key="UPlainAttr_owner_Index">CREATE INDEX UPlainAttr_owner_Index on UPlainAttr(owner_id)</entry> + <entry key="UPlainAttr_schema_Index">CREATE INDEX UPlainAttr_schema_Index on UPlainAttr(schema_id)</entry> + <entry key="UPlainAttr_membership_Index">CREATE INDEX UPlainAttr_membership_Index on UPlainAttr(membership_id)</entry> + + <entry key="GPlainAttr_owner_Index">CREATE INDEX GPlainAttr_owner_Index on GPlainAttr(owner_id)</entry> + <entry key="GPlainAttr_schema_Index">CREATE INDEX GPlainAttr_schema_Index on GPlainAttr(schema_id)</entry> + + <entry key="APlainAttr_owner_Index">CREATE INDEX APlainAttr_owner_Index on APlainAttr(owner_id)</entry> + <entry key="APlainAttr_schema_Index">CREATE INDEX APlainAttr_schema_Index on APlainAttr(schema_id)</entry> + <entry key="APlainAttr_membership_Index">CREATE INDEX APlainAttr_membership_Index on APlainAttr(membership_id)</entry> - <entry key="UPlainAttr_owner_idindex">CREATE INDEX UPlainAttr_owner_idindex on UPlainAttr(owner_id)</entry> - <entry key="GPlainAttr_owner_idindex">CREATE INDEX GPlainAttr_owner_idindex on GPlainAttr(owner_id)</entry> - <entry key="APlainAttr_owner_idindex">CREATE INDEX APlainAttr_owner_idindex on APlainAttr(owner_id)</entry> + <entry key="CPlainAttr_owner_Index">CREATE INDEX CPlainAttr_owner_Index on CPlainAttr(owner_id)</entry> + <entry key="CPlainAttr_schema_Index">CREATE INDEX CPlainAttr_schema_Index on CPlainAttr(schema_id)</entry> <entry key="Task_executedIndex">CREATE INDEX Task_executedIndex ON Task(executed)</entry> </properties>