This documentation is not using the current rendering mechanism and will be deleted by December 31st, 2020. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
Some of the SQL statements performed on the pages table in TYPO3 perform extensive operations while copying page-trees. These operations can be speeded by by adding 2 indexes to the standard table pages.
The indexes are: * content_from_pid_deleted (content_from_pid, deleted), * doktype_no_search_deleted (doktype, no_search, deleted)
It is not required that these indexes are created by in above scenarios considerable performance gains can be achieved.