Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Enhancement] removing unnecessary Indexes using more storage than needed #4605

Open
billmask opened this issue Jun 21, 2021 · 3 comments · May be fixed by #4565
Open

[Enhancement] removing unnecessary Indexes using more storage than needed #4605

billmask opened this issue Jun 21, 2021 · 3 comments · May be fixed by #4565
Labels
enhancement New feature or request Internal-Issue-Created An issue has been created in NextGen's internal issue tracker RS-6411 triaged

Comments

@billmask
Copy link

Is your feature request related to a problem? Please describe.
There is no wrong behavior of the application but there are unnecessary indexes in the databases XMl files.
This slow down the DMLs and does not help with queries but main problem is storage usage.

Describe your use case
Reduce storage usage and speed up DMLs.

Describe the solution you'd like
Just see the PR #4565

Describe alternatives you've considered
None

Additional context

Expected behavior
Less indexes (I am preparing a Pull Request) to speed up DMLs and save storage.

Actual behavior
Duplicated indexes in place.

Environment (please complete the following information):

  • Oracle
  • PostgreSQL
  • MySQL
  • SQL Server
@billmask billmask added the enhancement New feature or request label Jun 21, 2021
@billmask billmask mentioned this issue Jun 21, 2021
Closed
@billmask
Copy link
Author

@tonygermano Moved into here

@pladesma pladesma added Internal-Issue-Created An issue has been created in NextGen's internal issue tracker RS-6411 triaged labels Jun 21, 2021
@cturczynskyj cturczynskyj linked a pull request Sep 30, 2021 that will close this issue
Commented 2 unnecessary indexes present in a few D_MC and D_MM tables. #4565
Open
@billmask
Copy link
Author

@cturczynskyj It is supposed that I should merge it?

@pladesma
Copy link
Collaborator

@billmask We have an internal backlog item created to look at your pull request, but it isn't prioritized yet, so we don't have an exact estimate of when it will be merged. As of now, there are no additional actions you need to take regarding your pull request.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request Internal-Issue-Created An issue has been created in NextGen's internal issue tracker RS-6411 triaged
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Commented 2 unnecessary indexes present in a few D_MC and D_MM tables. billmask/connect
2 participants
@pladesma @billmask