Adjust indexes for Op History table

Reordered one index to put requestId first, as that should significantly
reduce the number of index entries to be examined.
Added endtime to another index, which should also reduce the number of
index entries to be examined for look-ups by time.

Issue-ID: POLICY-2874
Change-Id: I29c10fb9cabb22b3520ed1b14d7fe3fd9db40a15
Signed-off-by: Jim Hahn <jrh3@att.com>

diff --git a/models-interactions/model-impl/guard/src/main/java/org/onap/policy/guard/OperationsHistory.java b/models-interactions/model-impl/guard/src/main/java/org/onap/policy/guard/OperationsHistory.java
index 7354fff..0e66217 100644 (file)
--- a/models-interactions/model-impl/guard/src/main/java/org/onap/policy/guard/OperationsHistory.java
+++ b/models-interactions/model-impl/guard/src/main/java/org/onap/policy/guard/OperationsHistory.java
@@ -2,7 +2,7 @@
  * ============LICENSE_START=======================================================
  * ONAP
  * ================================================================================
- * Copyright (C) 2020 AT&T Intellectual Property. All rights reserved.
+ * Copyright (C) 2020-2021 AT&T Intellectual Property. All rights reserved.
  * ================================================================================
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -33,9 +33,9 @@ import javax.persistence.Table;
 import lombok.Data;
 
 @Entity
-@Table(name = "operationshistory",
-                indexes = {@Index(name = "operationshistory_clreqid_index", columnList = "closedLoopName,requestId"),
-                                @Index(name = "operationshistory_target_index", columnList = "target,operation,actor")})
+@Table(name = "operationshistory", indexes = {
+                @Index(name = "operationshistory_clreqid_index", columnList = "requestId,closedLoopName"),
+                @Index(name = "operationshistory_target_index", columnList = "target,operation,actor,endtime")})
 @Data
 public class OperationsHistory implements Serializable {