SET INDEX CACHE PRIORITY

Home

4D v20.6


SET INDEX CACHE PRIORITY ( aField ; priority )

Parameter	Type	Description
aField	Field	Field whose index(es) priority value has to be set for the session
priority	Longint	Cache priority value for the field index(es)

Expert mode

This command is reserved for specific needs. It must be used with care since it can affect database performance.

The SET INDEX CACHE PRIORITY command sets a specific priority to the index(es) related to the aField in cache for all processes in the current session. This command should be called in the On Startup or On Server Startup database method.

Note: This command only works in local mode (4D Server and 4D); it cannot be used in 4D remote mode.

This command handles priority for all indexes related to the aField, including keyword indexes (composite indexes priority cannot be customized).

In the priority parameter, pass one of the following constants from the "Cache Management" theme:

Constant	Comment
Cache priority low
Cache priority very low
Cache priority normal	Sets the cache priority to its default value
Cache priority high
Cache priority very high

Example

In the , you want to set a high priority for the [Customer]LastName field indexes:

SET INDEX CACHE PRIORITY([Customer]LastName;Cache priority very high)