Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Keyword - Test server - extremely slow search

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Keyword - Test server - extremely slow search. Searches are taking at least thirty seconds; many are timing out.

    Resolution:
    The following SQL (from KB 8192-6423) showed that the z101_id Oracle index was missing:

    abc01@ALEPH20> select index_name from all_indexes where owner = 'USM01' and index_name like 'Z%' minus select index_name from all_indexes where owner = 'ABC01' and index_name like 'Z%' and status = 'VALID';

    **** Hit return to continue ****

    INDEX_NAME
    ------------------------------
    Z101_ID


    The z101 is the "Sort index". It is used in producing the Brief List, as the final step in a keyword search.

    util a/17/2 to build the z101_id failed, but running util a/17/18, as described in KB 8192-424, worked.

    This corrected the keyword searching slowness/timeout.

    • Article last edited: 10/8/2013