#73167Indexes on deleted and hidden
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.