Issue Bug Closed

#73167Indexes on deleted and hidden

Sven Burkert 02/07/16, 07:52 updated 09/06/16, 10:04

Description

Doesn’t it make sense to define an index on the fields “deleted” and “hidden” to improve performance?

KEY visibility (deleted,hidden)

99% of the queries for table “pages” and “tt_content” contain “WHERE deleted=0 AND hidden=0” so this index should speed these queries up.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.