- Article Type: General
- Product: Aleph
- Product Version: 20
Keyword - Test server - extremely slow search. Searches are taking at least thirty seconds; many are timing out.
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 ****
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