• 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