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

DB Maintenance scripts #42

Open
mohandivraniya opened this issue Oct 25, 2024 · 5 comments
Open

DB Maintenance scripts #42

mohandivraniya opened this issue Oct 25, 2024 · 5 comments
Assignees
@RiteshKolhe
Labels
enhancement New feature or request

Comments

@mohandivraniya
Copy link
Collaborator

We need a script to get list of tables on which we need to perform maintenance, like:

  • Index rebuild, re-organize
  • Update statistics
  • Shrink
@RiteshKolhe RiteshKolhe self-assigned this Oct 25, 2024
@RiteshKolhe RiteshKolhe added the enhancement New feature or request label Oct 25, 2024
@RiteshKolhe
Copy link
Collaborator

Hi Prafull,
I am taking this task, will check and explore the details.

@prafullmaru
Copy link
Owner

@RiteshKolhe - Sure.

@RiteshKolhe
Copy link
Collaborator

Thanks, will take a look

@RiteshKolhe
Copy link
Collaborator

Hi Prafull,
I have prepared the DB scripts, It tested in Dev db and working as expected, Let me share the Pupp request, please get it reviewed and let us know your feedback.

RiteshKolhe pushed a commit that referenced this issue Oct 29, 2024
DB Maintenance scripts #42 => 1)Index rebuild and re-organize 2) Upda…
bf4f7be 
…te statistics 3) Shrink
@RiteshKolhe
Copy link
Collaborator

#46
Please check the PR and review and approve it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@RiteshKolhe RiteshKolhe

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@mohandivraniya @RiteshKolhe @prafullmaru