---
title: "Database"
manual: "Apache Solr for TYPO3"
version: "13.1"
permalink: "https://docs.typo3.org/permalink/apache-solr-for-typo3/solr:database@13.1"
source: "Database/Index.rst"
modified: "2026-09-16T15:16:05+00:00"
---

# Database

## Database indexes

Some of the SQL statements performed on the pages table in TYPO3 perform extensive operations while copying
page-trees. These operations can be speed up 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.