Web OPAC and GUI Search keyword searches (Find), extremely slow / time out

•  
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
Web OPAC and GUI Search keyword searches (Find), are extremely slow and usually time out.

Resolution:
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.)