Issue Bug Closed

#81097Extension Manager uses a query on a column that is not indexed

Claus Due 05/01/17, 17:27 updated 10/02/18, 10:59

Description

Query:

SELECT a.uid AS uid FROM tx_extensionmanager_domain_model_extension a LEFT JOIN tx_extensionmanager_domain_model_extension b ON a.repository = b.repository AND a.extension_key = b.extension_key AND a.integer_version < b.integer_version WHERE a.repository = 1 AND b.extension_key IS NULL ORDER BY a.uid

Current indexes:

PRIMARY KEY (uid),
KEY index_extrepo (extension_key,repository),
KEY index_versionrepo (integer_version,repository),
KEY index_currentversions (current_version,review_state),
UNIQUE versionextrepo (extension_key,version,repository)

Suggested indexes including index for query above:

PRIMARY KEY (uid),
KEY index_extrepo (extension_key,repository),
KEY index_versionrepo (integer_version,repository),
KEY index_versionrepoext (integer_version,repository,extension_key),
KEY index_currentversions (current_version,review_state),
UNIQUE versionextrepo (extension_key,version,repository)

Reviews 2