Precomputing sort indices on a dimension

Precomputing sort can save query time.

To precompute sort indices on a dimension:

In the Dimensions view, double-click the dimension you want to change to open its Dimension editor.
On the General tab, check Prepare Sort Offline.
Click OK.

Note:

An explicit record sort key, specified as part of a MDEX Engine query, takes priority over any other type of record sorting (default sorting and relevance ranking). See "Controlling the order of record results" for details.
If the Web application does not specify sort order as part of the query, the MDEX Engine returns records in the default sort order, if one has been specified. See "Specifying a default record sort order" for details.
Record sorting only affects the order of records. It does not affect the ordering of dimensions or dimension values that are returned for query refinement. You use dimension and dimension value ranking to affect the order of dimensions and dimension values.

Fully implementing this feature requires additional work outside of Developer Studio. Please refer to the Endeca Basic Development Guide for details.