Last updated on NOVEMBER 03, 2016
Applies to:Oracle WebCenter Content - Version 10.1.3.3.0 and later
Information in this document applies to any platform.
The Server is a 10gR3 install with patch updates. System performance is bad going straight to
the database when using the query that is built from the Content Server with certain operators.
Anything that uses "is not null" will not use the Database index. Substring is also bad as
that will not use an DB index either. We are using CIS to send specific queries (Matches
operator) and starts with instead of substring but this doesn't fix the "is not null" problem.
What can be done to speed the queries?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms