Specifies how searches that combine both full text and relational query conditions are executed. The property takes a CBRQueryOptimization value. The property applies to the IBM Content Search Services engine only.

A full-text search on indexed content is a content-based retrieval (CBR) search. A relational search on properties is a database (DB) search. If the property is set to NONE (0 or null), the Content Engine always performs the CBR search first and the DB search second. If the property is set to DYNAMIC_SWITCHING (1), then the Content Engine dynamically determines whether to issue the CBR search first or the DB search first, optimizing performance for these types of searches.

In dynamic switching mode, the Content Engine switches from CBR first to DB first based on an estimated number of CBR hits. The estimate is compared to a threshold value, set in the CBRQueryDynamicThreshold property. If you set this property to DYNAMIC_SWITCHING, then you must also set the CBRQueryDynamicThreshold property.

In dynamic switching mode, CBR-first behavior can be forced by CBR searches that request rank order. To maintain dynamic switching behavior, you must enable the CBRQueryRankOverride property.

You can also set this property in combination with other object store properties to force DB-first search behavior. For information about configuring the server for a particular behavior, the tradeoffs involved, and the SQL query options to override this property, see CBR Query Optimization.

Namespace:  FileNet.Api.Core
Assembly:  FileNet.Api (in FileNet.Api.dll)

ToggleSyntax

Visual Basic (Declaration)
Property CBRQueryOptimization As Nullable(Of CBRQueryOptimization)
C#
Nullable<CBRQueryOptimization> CBRQueryOptimization { get; set; }
Visual C++
property Nullable<CBRQueryOptimization> CBRQueryOptimization {
	Nullable<CBRQueryOptimization> get ();
	void set (Nullable<CBRQueryOptimization> value);
}
JavaScript
function get_cbrQueryOptimization();
function set_cbrQueryOptimization(value);

ToggleRemarks

ToggleSee Also