CMR-9889: Adding in a new index to make it faster to delete granules and to not stop the job if one provider's granule deletion fails.

[eereiter]

Overview

What is the feature/fix?

Adding in a new index to make it faster to delete granules and to not stop the job if one provider's granule deletion fails.

What is the Solution?

Adding in a new index to make it faster to delete granules and to not stop the job if one provider's granule deletion fails.

What areas of the application does this impact?

job of deleting expired granules.

Checklist

• [ ] I have updated/added unit and integration tests that prove my fix is effective or that my feature works
• [ ] New and existing unit and int tests pass locally and remotely with my changes
• [x] I have removed unnecessary/dead code and imports in files I have changed
• [x] I have performed a self-review of my own code
• [x] I have commented my code, particularly in hard-to-understand areas
• [x] 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 44.00000% with 28 lines in your changes missing coverage. Please review.

Project coverage is 57.93%. Comparing base (2c77745) to head (2ac24a8).

Files	Patch %	Lines
.../src/cmr/metadata_db/data/oracle/granule_table.clj	56.66%	13 Missing :warning:
...ata_db/migrations/089_add_granule_delete_index.clj	25.00%	9 Missing :warning:
...adata-db-app/src/cmr/metadata_db/services/jobs.clj	0.00%	5 Missing :warning:
...etadata_db/migrations/088_add_meta_to_provider.clj	0.00%	1 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #2135 +/- ## ========================================== - Coverage 57.95% 57.93% -0.02% ========================================== Files 1042 1043 +1 Lines 70182 70184 +2 Branches 1995 1993 -2 ========================================== - Hits 40672 40664 -8 - Misses 27651 27661 +10 Partials 1859 1859 ```

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