About range

1-10 of 48Refresh
Manual
88

Setting and Tuning of JPA Queries

The Query and TypedQuery interfaces define various setting and tuning methods that may affect query execution if invoked before a query is run using getResultList or getSingleResult. Result Range (setFirstResult, setMaxResults) The setFirstResult and setMaxResults methods enable defining a result
Manual
78

FROM clause (JPQL / Criteria API)

a program, since both are used for iteration over objects. Range Variables Range variables are query ... name annotation element. Multiple range variables are allowed. For example, the following query ... is required when using multiple range variables. Iteration over about 1,000,000 database objects
Manual
51

Index Definition

execution. Indexes are especially efficient in lookup and range queries: SELECT p FROM Point p WHERE p.x ... AND p.x <= 80 By using an index on field x, ObjectDB can find the results using a range scan ... , the BTree is ordered by x values, so a range scan on x values is supported. On the other hand, if y
Manual
42

JPA Query Structure (JPQL / Criteria)

a range variable. Range variables define iteration over all the database objects of a binding entity class and its descendant classes. In the query above, c is a range variable that is bound to the Country ... of the c range variable, which in this case is actually all the Country objects in the database
Manual
29

JPA Criteria API Queries

the built query. Then a Root instance is created to define a range variable in the FROM clause. Finally, the range variable, c, is also used in the SELECT clause as the query result expression
Result
29

ObjectDB Object Database Features

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... ) and XML. Query parameters for efficient reuse of one query in multiple executions. Result range settings
Manual
29

UPDATE SET Queries in JPA/JPQL

* 11 / 10 The UPDATE clause defines exactly one range variable (with or without an explicit ... more field update expressions (using the range variable name - if defined). Multiple field update
Manual
29

Server User List

in a comma separated list and using a hyphen (-) to indicate a range. For example, a value "192.18.0.0-192.18.194.255,127.0.0.1" allows connecting from any IP address in the range of 192.18.0.0
JDO Doc
21

javax.jdo.Query

, import statements, ordering and grouping specifications, result and result class, the range ... collection or extent, result class, and range limits are not used. The String parameters are trimmed of white ... , except for specifying the range, result class, and ignoreCache option. The unmodifiable flag, when set, disallows
JPA Doc
21

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query Variables The FROM clause in JPA queries (as in SQL) defines the query variables. Query variables are represented in criteria queries by descendant interfaces of the From interface: Range variables