This is an automated email from the ASF dual-hosted git repository.
vorburger pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git
The following commit(s) were added to refs/heads/develop by this push:
new 6992102 FINERACT-1165
6992102 is described below
commit 6992102035cd83dc912847ab0bd706e2d8c36d29
Author: jagadeeshakn <[email protected]>
AuthorDate: Fri Oct 23 00:22:50 2020 +0530
FINERACT-1165
---
.../V363__mnote_indexing_for_performance.sql | 21 +++++++++++++++++++++
1 file changed, 21 insertions(+)
diff --git
a/fineract-provider/src/main/resources/sql/migrations/core_db/V363__mnote_indexing_for_performance.sql
b/fineract-provider/src/main/resources/sql/migrations/core_db/V363__mnote_indexing_for_performance.sql
new file mode 100644
index 0000000..a2e2ee8
--- /dev/null
+++
b/fineract-provider/src/main/resources/sql/migrations/core_db/V363__mnote_indexing_for_performance.sql
@@ -0,0 +1,21 @@
+--
+-- Licensed to the Apache Software Foundation (ASF) under one
+-- or more contributor license agreements. See the NOTICE file
+-- distributed with this work for additional information
+-- regarding copyright ownership. The ASF licenses this file
+-- to you under the Apache License, Version 2.0 (the
+-- "License"); you may not use this file except in compliance
+-- with the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing,
+-- software distributed under the License is distributed on an
+-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+-- KIND, either express or implied. See the License for the
+-- specific language governing permissions and limitations
+-- under the License.
+--
+
+ALTER TABLE `m_note`
+ ADD INDEX `savings_account_transaction_id`
(`savings_account_transaction_id`);
