About index

manual

Index Definition

Describes how to define indexes in JPA entity classes and explains how indexes are used in JPQL queries.... queries over millions of objects can be executed quickly. Index management introduces overhead in terms of maintenance time and storage ... covers the following topics: Single Field Index Composite Index Multi Part Path Index ...

 
forum_thread

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={"relationshipType"}) }) @XmlRootElement public class Relationship implements Comparable<Relationship> { ... Table @ Indices ( { @ Index ( members = { "relationshipType" , "party" } ) , @ Index ( members = { "relationshipType" , "otherParty" } ) , @ Index ( members = { "relationshipType" } ...

 
manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query.... 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 on the population field ObjectDB can use that index to ...

 
api-jdo

javax.jdo.annotations.Index

Annotation for a database index.(Annotation of JDO)

 
forum_thread

ObjectDB 2.7.2_x Doctor Yields "Index Requires Rebuild" Always

Take a .odb created with ObjectDB 2.7.2 or later OR EARLIER.  Run ObjectDB 2.7.2 Doctor on it.  See indexing errors reported. Run ObjectDB 2.7.1 on same .odb and you will not see indexing errors. Run ObjectDB 2.7.2 (or later or earlier) Doctor with repair and create repaired.odb.  repaired.odb will still show indexing errors when ObjectDB 2.7.2 (or later) Doctor is run on the "repaired" database. ... is run on the "repaired" database. Automatic index rebuilding ("<index-update enabled="true" priority="40" />") does not correct the ... 70 % 80 % 90 % 100 %   Index Errors ------------ [ 1 ] Index com. ...

 
forum_thread

Multi part paths in a composite index must have the same length

Hi, I am trying to create some index in a DB - but I get an exception when i try to commit. Exception in thread "main" [ObjectDB 2.6.0_01] javax.persistence.PersistenceException Invalid index path 'tStamp.value / instrumentId' in type Entities.OrderBookNew (error 328) at com.objectdb.jpa.EMImpl.createQuery(EMImpl.java:958)   Here is how the class of the persisted object looks like ... Hi, I am trying to create some index in a DB - but I get an exception when i try to commit. Exception in ... 2.6.0_01] javax.persistence.PersistenceException Invalid index path 'tStamp.value / instrumentId' in type Entities.OBN (error ...

 
forum_thread

Mysterious "Attempt to persist a reference to a non managed instance" error

I've been working with ObjectDB for the past several months, and it's behaved pretty much as expected. I made a few modifications to a working set of classes today, and it's started throwing exceptions at commit time. I've stripped it down to a  set of files that seem to be of trivial complexity, but it's still failing. It involves two entities, Index and Ostrich. The thing to note is that the Index structure is recursive through maps; but that's never caused any problem for me in the past. ... it's still failing. It involves two entities, Index and Ostrich. The thing to note is that the Index structure is recursive through maps; but that's never caused any ...

 
forum_thread

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 start with some example then. Assume we have an entity that represents an interior design image, called Inspiration : ... for JPA Entities (http://www.objectdb.com/java/jpa/entity/index), but I still have some problems understanding how and when should I use ... : #1. First of all - the first member in composite index should be a field that is most commonly used in WHERE clauses or maybe ...

 
forum_thread

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 List<ObjectNode> objectsInCharge = new ArrayList<ObjectNode>(); on running a query like ... we defined a composite index for class Action: @ Index ( name = "ssst" , members = { "startDate" ...

 
api-jdo

JDO Annotations for Index Definition

... on persistent fields: javax.jdo.annotations.Index javax.jdo.annotations.Indices ... javax.jdo.annotations.Uniques The Index Definition section of the ObjectDB manual explains these annotations ...