You can optimize the performance of a CBR query by controlling
the order of the two main constituent searches for the query. These
two searches are the database search and the full-text search.
About this task
Database-first execution is more efficient in the following
circumstances:
- The number of database search hits is small; in the typical case,
this number is less than a few hundred
- The number of full-text search hits is large; in the typical case,
this number is more than several thousand
For your object store, what constitutes a small and large
number of search hits can vary from the typical case.
Procedure
To change the query optimization settings for an object
store:
- Access the CBR query optimization properties in the administration
console:
- In the domain navigation pane, click the object store.
- In the object store navigation pane, click the name
of the object store (the top-level item).
- In the details pane, click the Query tab.
- Change the values for the properties in the CBR Query Optimization
section as appropriate.
- Save your changes.