 368 | Querying without indexes requires iteration over entity objects in the database one by one. This may take a significant amount of time if many entity objects have to be examined. Using proper indexes ... . Index management introduces overhead in terms of maintenance time and storage space, so deciding |
230 | The following annotations are used to define indexes on persistent fields: The Index Definition section of the ObjectDB manual explains these annotations in details. |
80 | 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 |
80 | javax.jdo.annotations Annotation Index Target: Classes and fields (including property get methods) Annotation for a database index. Used for database schema generation to create indexes. Corresponds to the xml element "index". Since: JDO 2.1 Column[] columns Columns that compose this index. Columns |
71 | Annotation Element javax.jdo.annotations.Index String table Table for the index. This is needed iff annotating a type where the index is not defined on the primary table for the type. Returns: the table on which the index is defined Default value: "" Since: JDO 2.1 |
70 | Annotation Element javax.jdo.annotations.Discriminator String indexed Whether the discriminator is indexed. Returns: whether the discriminator is indexed Default value: "" Since: JDO 2.1 |
70 | Annotation Element javax.jdo.annotations.Element String index The name of the index to generate. Returns: the name of the index Default value: "" Since: JDO 2.1 |
70 | Annotation Element javax.jdo.annotations.Element String indexed Whether the value column(s) should be indexed. Returns: whether the value column(s) should be indexed. Default value: "" Since: JDO 2.1 |
70 | Method javax.persistence.criteria.ListJoin Expression index() Create an expression that corresponds to the index of the object in the referenced association or element collection ... for which an order column has been defined. Returns: expression denoting the index Since: JPA 2.0 |
70 | Annotation Element javax.jdo.annotations.Index Column[] columns Columns that compose this index. Returns: columns that compose this index Default value: {} Since: JDO 2.1 |