What is the effect of setting the value "ALL_ROWS"  for OPTIMIZER_GOAL parameter of the ALTER SESSION  command ?

This  value  causes  the  optimizer to the cost-based approach for  all SQL statements  in  the session regardless of the presence of statistics and to optimize with a goal of best throughput.

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions