JPA 配置 复合索引

 

@Table(indexes = {
        @Index(columnList = "xxx"),
        @Index(columnList = "ddd"),
        @Index(name="IDX_Xueke_Name_ShareType_Owner",columnList = "name"),
        @Index(name="IDX_Xueke_Name_ShareType_Owner",columnList = "shareType"),
        @Index(name="IDX_Xueke_Name_ShareType_Owner",columnList = "owner"),

})

复合索引配置，注意 name 相同就可以了。 

复合索引字段顺序就是 @Index中字段的顺序，注意 最佳左前缀特性。