[Bug]: Obsolete index jobs.job_class_index

[ChristophWurst]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

1. core/Migrations/Version13000Date20170718121200.php adds the oc_jobs table and an index on (class)
2. core/Migrations/Version24000Date20211230140012.php adds the oc_jobs.argument_hash and an index on (class, argument_hash)

create index job_class_index
    on nextclouddev.oc_jobs (class);

create index job_argument_hash
    on nextclouddev.oc_jobs (class, argument_hash);

The second index can be used in queries that only filter for the class, making the older index obsolete. This leads to more index maintenance work of the database. The old index should be dropped.

Steps to reproduce

1. Install Nextcloud

Expected behavior

Efficient use of database indexes.

Nextcloud Server version

30

Operating system

None

PHP engine version

None

Web server

None

Database engine version

None

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

No response