Using indexed properties

Indexed properties are properties that have been retrieved from the APS InfoStore and stored in the server's memory. As such, they can be retrieved very quickly. Indexed properties are useful in situations where only a certain number of objects need to be retrieved; however, in order to determine which objects these are, some of their properties must be examined first.

Consider, for example, a case where the first five reports from a list—that is sorted by name in descending order—are to be displayed. It would be more efficient to retrieve only the SI_NAME property for all the reports (SI_NAME is an indexed property), sort the list, and then re-query the APS for the rest of the reports' details. Although the APS is queried twice, this method will be much faster than retrieving all the report properties for all reports, sorting the list, and then discarding the unwanted reports.

Tip:    For examples of how to optimize a query using an indexed WHERE clause, see Constructing the WHERE clause.

The following is a list of all properties that are indexed.

Property
SI_ID Property
SI_PARENTID Property
SI_OWNERID Property
SI_UPDATE_TS Property
SI_NAME Property
SI_INSTANCE Property
SI_FLAGS Property
SI_HIDDEN_OBJECT Property
SI_PROGID Property
SI_STARTTIME Property
SI_ENDTIME Property
SI_SCHEDULE_STATUS Property

Note:    In this version of Crystal Enterprise, the SI_NAME property is indexed for all objects, including instances.