JBAS-1604 Vandelay queue delete speedup indexes
authorBill Erickson <berickxx@gmail.com>
Fri, 30 Sep 2016 14:56:51 +0000 (10:56 -0400)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commit28fdfa811d89e26e96d2743a4ebfe78ea36b99e8
tree87d39cb905a5143d0e741b60d58471b30c082423
parent0668a32b855cdc06509f004f63e22beca6dbe740
JBAS-1604 Vandelay queue delete speedup indexes

Add indexes to make deleting vandelay queue data faster, specifically
when vandelay records link to import items and acq lineitems.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
KCLS/sql/schema/deploy/vand-delete-speed-indexes.sql [new file with mode: 0644]
KCLS/sql/schema/revert/vand-delete-speed-indexes.sql [new file with mode: 0644]
KCLS/sql/schema/sqitch.plan
KCLS/sql/schema/verify/vand-delete-speed-indexes.sql [new file with mode: 0644]