About index

41-50 of 200Refresh
Forum
16

Is there an administration tool with which I could create extra indexes?

Hello, I have composite index, and it was working fine, but now I need to add more features to the software and I need to throw more indexes in there. I wanted to know what's the best way to do this. 1. Have some admin tool CREATE INDEX..... ON a.b or 2. add more @Index to the object entities. in
Forum
15

Adding indexes on existing entities.

Is it safe to add indexes on an existing entity class? Thanks. Safe, but to enable the new index ... that the index is registered in the database by opening the database when it has access to the new index ... . Update: Starting ObjectDB 2.6.6 new indexes are automatically built and activated in the background
Forum
15

is JDO field attribute "indexed" supported?

seem to have specific documentation for this. Your documentation for JDO annotation @Index mentions that it corresponds to the XML <index> element which is one way to specify indexes in XML metadata. But there is another way which is to specify an indexed attribute on the field element, like
Forum
15

Create simple index for a Id field

Hello, I just wanted to write another anotation to my key field so I can have a really simple index ... just want my key to be indexed on my db, just like this: @Entity public class ObjectDbEntity implements DataItemProvider {        @Id     @Index     private Key key = null
Forum
15

JDO @Index in JPA?

Hi! I have a project which has all entities as JPA entities. I would like to make use of indexing ... : will adding JDO @Index in a JPA entity have any effect or I have to switch that entity to JDO? Question2 ... with JPA without any additional change. If you add an index to an existing entity class
Issue
15

Can not have unique index on Byte Array

more Unique is implemented by ObjectDB by an index that does not allow duplicate keys. An index ... . Note also that an index on a collection or array will not be useful in queries that compare ... the collection or array, e.g. using a JOIN query. This is because every element is indexed as
Forum
15

"Rebuild Class Indexes" from the command line?

Hi, Is there a way to "Rebuild Class Indexes" from the command line? I have just added a new index ... . http://www.objectdb.com/database/jdo/manual/chapter9 Thanks   Rebuilding an index currently requires ... . Update: Starting ObjectDB 2.6.6 new indexes are automatically built and activated in the background. EKK
Forum
15

Are indexes implicitly created for relationships?

Do the following annotations @OneToMany @ManyToOne @ManyToMany @OneToOne imply @Index  ? Thanks ... on the @One side. But ObjectDB doesn't apply these indexes automatically, because of their overhead (which most users are not aware of). You should use the @Index or @Unique annotations explicitly to set indexes. FastModel
Forum
15

Index on values from a Map

Hi, is there a way to put an Index on the values from an Map? For example, if I have a Map like ... : Collection values = mmsContainer.values();   Thanks for you help   Indexes are used only in queries, and cannot accelerate other application code. You can define an index on a map
Forum
15

Indexes broken after schema update.

to pick up the new schema and now none of the indexes work, except the @Id. I can query by any field that is not indexed on the existing Object but as soon as I try and query against a field that was indexed I get no results. Tried 2.4.2 and 2.4.2_02 with same results. Adding new persistent fields