An important area of application for replications and partial replications is to reduce the burden on DBHs in the OLTP operation of read-only applications which do not necessarily need the latest version of the data (e.g. for evaluations and statistics).
Retrieval using partial replications
The database administrator can decide to use only a partial replication. This partial replication contains only those parts of the database which are required by the current application. A partial replication requires less space and can be created and updated more quickly.
A partial replication must always be complete in itself, i.e. the partial replication must contain all the indexes for all the tables which belong to the partial replication.
SESAM/SQL responds with the SQL status code “index or space inaccessible” if indexes or tables which are not part of the partial replication are accessed.