Search Specification
The Search Specification property for a business component, applet,
link, or picklist selectively retrieves rows from the underlying table
that meet the criterion specified in the property. The search specification
is the basis for the WHERE clause in the resulting SQL
issued. An index needs to be present that supports the criterion. Otherwise,
the RDBMS might scan through all rows in the table rather than only those
to be returned by the query.
The index needs to contain all of the columns referenced by fields in the search specification.
In Sales Rep views such as My Accounts or where organization access
control is implemented, if the user queries or sorts columns that are
denormalized to the intersection table (for example, NAME
and LOC in S_ORG_EXT), then performance
is likely to be good. The Siebel application uses the intersection to
determine visibility to records in the base table, and indexes can be
used on the intersection table to improve performance.
For related information, see Reusing Standard Columns.