Skip to main content
Ex Libris Knowledge Center

Which tables are index, temporary, and base tables?


  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care


Which tables in the system are base or "corpus" tables (permanent tables which can not be re-constructed from other tables) and which are indexes (can be reconstructed from other tables) or temporary?


These tables can be reconstructed from other tables: 
z00p, z00r, z01, z0101, z0102, z02, z101, z103, z11, z111, z13, z13u, z120, z127, z301, z320, z321, z353, z403, z79, z95, z97, z970, z98, and z980.

These are temporary (result set, session, or lock tables): 
z05, z110, z130, z131, z200, z50, z51, z60, z63, z64, and z65. [Note: all of these except the z50 occur only in the VIR01 library.]

The z34 and z69 are OPAC statistics tables; the z35 is used for statistics, especially circ statistics. 

The above lists may not be complete but, generally, other tables should be considered as base tables.



  • Article last edited: 28-Feb-2016
  • Was this article helpful?