- Product: Aleph
- Product Version: 20, 21, 22, 23
Web OPAC and GUI Search keyword searches (Find), are extremely slow and usually time out.
The primary tables involved in keyword searching are z95, z97, z98, and z980.
Checking with util a/17/14, we found that the z98_id Oracle index was not present.
Running util a/17/2 to rebuild it was unsuccessful because of duplicates:
CREATE UNIQUE INDEX XXX01.Z98_ID ON XXX01.Z98 (Z98_REC_KEY ASC)
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Running util a/17/18 to delete the duplicates (and create the unique index) was successful. (See article Cannot CREATE UNIQUE INDEX; duplicate keys found; using util a/17/18 **HOW TO** (KB 8192-424) for details on util a/17/18.)
- Article last edited: 22-Mar-2016