Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/goodsstock/GoodsStock.java
===================================================================
diff -u -r16861 -r17152
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/goodsstock/GoodsStock.java	(.../GoodsStock.java)	(revision 16861)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/goodsstock/GoodsStock.java	(.../GoodsStock.java)	(revision 17152)
@@ -4,6 +4,8 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
+import javax.persistence.Table;
 import javax.persistence.Transient;
 
 import org.hibernate.annotations.Cache;
@@ -17,6 +19,10 @@
  * @since 2016-03-21
  */
 @Entity
+@Table(indexes = {@Index(columnList = "wareHouseId", name = "wareHouseId_index"),@Index(columnList = "orgUnitCode", name = "orgUnitCode_index")
+,@Index(columnList = "tousseDefinitionId", name = "tousseDefinitionId_index"),@Index(columnList = "materialDefinitionId", name = "materialDefinitionId_index")
+,@Index(columnList = "name", name = "name_index"),@Index(columnList = "materialEntryItemId", name = "materialEntryItemId_index")
+})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 @JsonFilter("fieldFilter")
 public class GoodsStock {