CMR-10020 - Adding indexes to granule tables to speed up DB queries for cleaning up old concepts.

[eereiter]

Overview

What is the feature/fix?

Adding indexes to granule tables to speed up DB queries for cleaning up old concepts.

What is the Solution?

Adding indexes to granule tables to speed up DB queries for cleaning up old concepts.

What areas of the application does this impact?

Granule Tables

Checklist

• [ ] I have updated/added unit and integration tests that prove my fix is effective or that my feature works
• [X] New and existing unit and int tests pass locally and remotely with my changes
• [ ] I have removed unnecessary/dead code and imports in files I have changed
• [X] I have performed a self-review of my own code
• [ ] I have commented my code, particularly in hard-to-understand areas
• [ ] I have made corresponding changes to the documentation
• [X] My changes generate no new warnings
• [ ] I have cleaned up integration tests by doing one or more of the following:
  • de-duped, consolidated, removed dead int tests
  • transformed applicable int tests into unit tests
  • refactored to reduce number of system state resets by updating fixtures (use-fixtures :each (ingest/reset-fixture {})) to be :once instead of :each

[codecov-commenter]

Codecov Report

Attention: Patch coverage is 12.50000% with 21 lines in your changes missing coverage. Please review.

Project coverage is 58.13%. Comparing base (b665910) to head (97fe12f). Report is 1 commits behind head on master.

Files	Patch %	Lines
...grations/090_add_granule_delete_revision_index.clj	25.00%	9 Missing :warning:
...adata-db-app/src/cmr/metadata_db/services/jobs.clj	0.00%	8 Missing :warning:
.../src/cmr/metadata_db/data/oracle/granule_table.clj	0.00%	4 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #2146 +/- ## ========================================== - Coverage 58.14% 58.13% -0.01% ========================================== Files 1043 1044 +1 Lines 70241 70250 +9 Branches 2011 2005 -6 ========================================== + Hits 40840 40841 +1 - Misses 27531 27538 +7 - Partials 1870 1871 +1 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.