Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the effect of setting the value â€ŔCHOOSE†for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

Command optimizer_goal parameter session setting value
0
Posted

What is the effect of setting the value â€ŔCHOOSE†for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

0 CommentsAdd a Comment

1 Answer

0

– The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

0 CommentsAdd a Comment

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123