Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Does TAB z01 have an IND z01_id6?

    Does TAB z01 have an IND z01_id6?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We're concerned that we're missing an index for TAB z01. In v18, does z01 have a z01_id6?

    I didn't find one in .../aleph/tab/file_list.* and in the usmxx file_lists but there is one in .../alephm/sql_tab/, z01_create_index_6.sql. The .../aleph/tab/file_list.ADM and .../aleph/tab/file_list.BIB have just 4 indexes, z01_id, z01_id1-z01_id4 where the AUT, COURSE, ILL, HOL, and VIR file_lists have 5 indexes, z01_id, z01_id1-z01_id5.

    Resolution:
    Index z01_id6 is an index by Z01_REF_TYPE column, which is 1 character long and can have one of two values: blank or “U” (please see table structure description in tables documentation).

    There is rarely a reason to build index on a field which can have only two values and probably will be never used by Oracle unless a specific hint to use it is given. In such case it even might slow down the queries.

    The existence of the script in sql_tab directory does not disturb any functionality of ALEPH and, thus, does not need to be removed. You can just ignore it.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Does stopping job daemon keep all jobs from running or just job_list jobs?
      • Does Toggling Circ Down in util w/5 Prevent User Holds and Renewals in OPAC?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved