ISS Searches And Results Are Taking Too Long (Doc ID 1996238.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Communications Indexing and Search Service - Version 1.0 and later
Information in this document applies to any platform.

Symptoms

ISS 1u5 p23

Search is taking longer than expected because it is returning with too many matches:

Sat Feb 07 23:10:17 UTC 2015 com.sun.comms.iss.search.SearchImpl search INFO:query number: 1081, 14964 total matching documents to query: +username:jsmith +hostname:ms.domain.com +folder:"INBOX"
+( from:Oracle ( subject:Oracle ( to:Oracle ( cc:Oracle body:Oracle)))) -deleted:true, search time was 11067ms


This one user's account contains over 279000 emails

There is a reported bug which might be causing the large number of matches:

17969121 - Searching BODY with OR terms returns extraneous matches

However, this is not the case that's happening here.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms