RBO to CBO

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Sat, 8 Jan 2005 10:41:45 -0500
Message-ID: <KcGdnYjnwM-NYkLcRVn-tQ@comcast.com>

what parameters to pay attention to other than the following moving from RBO to CBO?
It is an OLTP instance.

optimizer_mode
optimizer_features_enable
optimizer_index_caching
optimizer_index_cost_adj
optimizer_dynamic_sampling
optimizer_max_permutations

What about these two parameters?
hash_area_size
hash_join_enabled

Thanks Received on Sat Jan 08 2005 - 09:41:45 CST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]