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. SQL "select count" is slow

    SQL "select count" is slow

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    SQL "select count" on certain Aleph tables takes minutes to run (-- rather than the expected seconds).

    Cause:
    If the underlaying table has not been recreated in many years and the main Oracle index (such as, z30_id, z01_id, etc.) has, likewise, not been rebuilt in many years, and there have been many additions-to / deletions-from the table, the Oracle index can become fragmented. {util a/17/15 ("Analyze Index") is intended to show the degree of fragmentation of the index.}

    Resolution:
    Running util a/17/3 to recreate the Oracle indexes -- especially the znn_id index -- has been shown, at least in some cases, to *drastically* improve the response time on "select count".

    Additional Information

    It's unclear what the effect is on slowness in performing actual Aleph functions, but it would seem that the above would improve the performance of any function reading through the table sequentially.

    Category: Oracle (500)


    • Article last edited: 10/23/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Splitting Services output files into smaller batches for loading
      • SQL Access to Frequency data
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. 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