This content has been marked as final. Show 3 replies
Although it may not answer your question directly, you may want to refer to this whitepaper:
[Performing Queries in Oracle Berkeley DB Direct Persistence Layer|http://www.oracle.com/technetwork/products/berkeleydb/performing.pdf]
Thanks for the reply..
I have already gone through this doc. it says only for AND Condition (EntityJoin).
I thought the white paper at least mentioned OR conditions, but perhaps it doesn't go into enough detail.
You have two choices.
1) Scan all records and filter them using the two conditions.
2) Do two queries, one for each condition, and union the results.
In other words, there is nothing built-in that helps you with this. You have to implement the query yourself. And you have to decide which approach will perform best, preferably based on testing.
For example, a full scan (option 1) can be very expensive if you have a large number of records, so option 1 is usually more expensive than option 2. But on the other hand, if the majority of all records qualifies (will be selected by the query), then a full scan may be the most efficient option.