Add secondary indices to operationshistory table 09/108109/1
authorJim Hahn <jrh3@att.com>
Thu, 21 May 2020 21:47:18 +0000 (17:47 -0400)
committerJim Hahn <jrh3@att.com>
Thu, 21 May 2020 21:52:16 +0000 (17:52 -0400)
commit6dc566131200f634d54cc27712518bb163885cb0
tree97653cba3df053bd48823d6aa7406b8e14037834
parent43bdc71a161c3c22b56c9eb801ed3c7771883077
Add secondary indices to operationshistory table

Queries to the operationshistory table will degrade substantially
as more records are added to the DB.
The Dbao class should be moved to policy-models, but for now
we'll just update it in both places (i.e., drools-apps and xacml-pdp).

Issue-ID: POLICY-2581
Change-Id: Ic43cefdfd4d353b73d815bd629ef25f3d2b486c6
Signed-off-by: Jim Hahn <jrh3@att.com>
controlloop/common/database/src/main/java/org/onap/policy/database/operationshistory/Dbao.java