About index

21-30 of 200Refresh
Manual
33

Chapter 2 - JPA Entity Classes

Explains how to define and use JPA entity classes and other JPA persistable types.
Issue
25

combined index not used

.nodePath, a.objectsInCharge.properties.doubleValue In the class Action we have a combined index (see attachment) but in the query plan we can see that this index is not used: Query Plan Description ... ------------------------------------ [Step 1a] Scan index com.agile.hummingbird.Action[endDate] locating all the Action (a) instances
Manual
24

WHERE clause (JPQL / Criteria API)

and then collected as query results. WHERE Predicate and Indexes Formally, the WHERE clause functions as a filter between the FROM and the SELECT clauses. Practically, if a proper index is available, filtering is done earlier during FROM iteration. In the above population query, if an index is defined
Forum
23

possible index required for improving query performance

Hi, I have the following entity class: @Entity @Table @Indices({ @Index(members={"relationshipType", "party"}), @Index(members={"relationshipType", "otherParty"}), @Index(members ... a linear way as the number of relationships and BaseObjects grow. The query is using two indexed fields
Forum
22

Composite indexes

Hi, I read your manual about defining Indexes for JPA Entities (http://www.objectdb.com/java/jpa/entity/index), but I still have some problems understanding how and when should I use them.   Let's ... ; // either true or false (...) }   Here are my questions regarding composite indexes : #1. First
Result
22

ObjectDB Object Database Features [2018-01-27]

other internal caches. Indexing Single field and multi field (composite) indices. Collection and array elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths inside embedded objects are indexable. Indices are also used for fast ordering and aggregate calculations
Result
22

ObjectDB Object Database Features [2018-10-27]

other internal caches. Indexing Single field and multi field (composite) indices. Collection and array elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths inside embedded objects are indexable. Indices are also used for fast ordering and aggregate calculations
Result
22

ObjectDB Object Database Features

result cache (for repeating queries with the same arguments). Many other internal caches. Indexing Single field and multi field (composite) indices. Collection and array elements are indexable (extremely fast JOIN queries). Map keys and values are indexable. Nested paths inside embedded objects
Forum
22

composite index not used in query

we defined a composite index for class Action: @Index(name="ssst",members={"startDate","state","subType","type"}) and an index for the OneToMany @OneToMany(fetch=FetchType.LAZY) @Index public ... ')) and (a.state = 3 and a.subType = 3 and a.type = 0 and a.startDate > ?1)) the composite index is not
Forum
22

Composite Index error 328

( { @javax.jdo.annotations.Index(members = {"id","pwd","access"}) } ) public class ... ; }     [ObjectDB 2.7.5_01] javax.persistence.PersistenceException Invalid index path 'id' in type ... .java:748) Caused by: com.objectdb.o.UserException: Invalid index path 'id' in type persistence.jpa