An optimization that helps some databases (mostly Oracle) choose the correct index when there are multiple candidate indexes with the leading edge. The search is a no-op, since for nonnull fields, searching for greater than ASCII 0 will return everything.
If this is a required field, the business component is in Sales Rep or Organization Visibility mode, and the Visibility field (position or organization) is in the same table as preceding field, optimize by adding a dummy search specification (for example, NAME >= '\1') on the first column of the business component sort specification.
Optimization can be disabled on the business component level by setting Sort Search Optimization to FALSE.
NOTE: Sort Search Optimization is always disabled for DB2.
