The Sort Search Optimization user property is an optimization that helps some databases (mostly Oracle) choose the correct index when there are multiple candidate indexes with the leading edge. For nonnull fields, searching for greater than ASCII 0 returns everything, therefore, the search is a not optimized. If this is a required field, the business component is in Sales Report Organization Visibility mode, and the Visibility field (position or organization) is in the same table as the preceding field. You optimize by adding a dummy search specification (for example, NAME >= '\1') on the first column of the business component sort specification. You can disable optimization at the business component level by setting Sort Search Optimization to FALSE. NOTE: Sort Search Optimization is always disabled for DB2.
|
