From 3031446fc890ac27d837df7b9e6b3d385de0fd43 Mon Sep 17 00:00:00 2001 From: Jim Hahn Date: Mon, 24 May 2021 11:39:42 -0400 Subject: [PATCH] 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 --- .../src/main/java/org/onap/policy/guard/OperationsHistory.java | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) 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 7354fff5d..0e66217f4 100644 --- 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 { -- 2.16.6