Fedora uses several database tables and indexes to provide fast retrieval of some information. This page will document the various tables Fedora creates. Because of differences in databases some datatypes might not match the implemented type in your database exactly (ie. datetime versus timestamp).
For more information on configuring which database to use, see the Properties page.
When a Fedora repository is started with an empty database it begins a reindex process to recreate these indexes from the content on disk. You can force this rebuild to occur by setting the fcrepo.rebuild.on.start JVM property to true. For more information again visit the Properties page (linked above)..
For more information on configuring which database to use, see the Database section on the Properties page. As well as checking out the Database Cache page.
Technical Information
...
Containment Index
The containment index is a series of tables/indexes used to track the ldp:contains relationships of containers in Fedora.
...