Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spaces in search filter modify performance

807573Dec 18 2002 — edited Dec 24 2002
Hi,

I have a customer that is seeing large differences in the performance of the following two queries:

(& (customattr1=test)(| (customattr2=x)(customattr2=y)))
( &(customattr1=test)( |(customattr2=x)(customattr2=y)))

the second filter is extremely slow.

thoughts?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details