About index

21-30 of 200Refresh
Manual
32

Chapter 2 - JPA Entity Classes

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

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
Forum
30

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
29

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
Forum
28

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
28

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
Issue
28

ObjectDB 2.7.2_x Doctor Yields "Index Requires Rebuild" Always

on it.  See indexing errors reported. Run ObjectDB 2.7.1 on same .odb and you will not see indexing errors. Run ... will still show indexing errors when ObjectDB 2.7.2 (or later) Doctor is run on the "repaired" database. Automatic index rebuilding ("<index-update enabled="true" priority="40" />") does not correct
Forum
27

Index causes increased memory usage

.  What could be taking up that memory?  The data load was the same for both tests (with and without String indexing ... on the server?   Thanks, CVTSC Using indexes should not make that difference. When indexes ... the indexes.  How are the indexes stored?  Is it simply a pointer to the field to be indexed, or
Forum
27

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 ... .createQuery(EMImpl.java:958)   Here is how the class of the persisted object looks like @Entity @Index
Forum
27

Adding multi part path index on non-embedable object member

Is there a way to add single member index on members of a object member which is not configured ... } So I wanted to add index on Customer for merchant.name or on stores.name given those merchant and Store class has the corresponding fields. e.g.  @Entity @Indices({ @Index(members={"merchant