An RQL query can use PROPERTY HINT to view hints within a particular query. When a property is specified with a PROPERTY HINT, the property is loaded with the initial query, which prevents return calls back to the database to retrieve the property value later. For example, the query would look like this:

brand = "BrandX" AND nonreturnable = false PROPERTY HINTS description,
displayName, template

This returns all items with the brand BrandX that are returnable. It also loads the description, displayName and template properties in the query. Because the template property is in an auxiliary table, it is loaded with a JOIN as of the next release.

If you were using this query to display information on a page, all of the information that you require is obtained from a single database query.

Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices