Which three factors influence the optimizer’s choice of an execution plan?
A.
the optimizer_mode initialization parameter
B.
operating system (OS) statistics
C.
cardinality estimates
D.
object statistics in the data dictionary
E.
fixed baselines
Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm
This questions said: “Which three factors” and only have two correct answers, i think you forgot one.
Third option will be D
A, C, E
http://docs.oracle.com/cd/B10500_01/server.920/a96533/optimops.htm
Sorry it is A, C, D!
ACD
A,C,D
a, c , d
A,C,D
A C D
why not A B D ?
those statistics are being used aswell by the optimizer
I think B-C-D
http://docs.oracle.com/database/121/TGSQL/tgsql_optcncpt.htm#TGSQL193
You are wrong. “Operating system statistics” are not the same like “Hardware statistics”.
The correct answers are: A,C,D
total confusion for me about the correct answer; this question is posed in gratis exam and the correct answer was A,B,D. Now you say here that the correct answer is A,C,D. Finally what is the correct answer?
The correct answers are: A,C,D
ACD
ACD
A, D and E
Techniques for Influencing the Optimizer such as
1- dbms_stas
2- sql profile,
3- hints
4- sql plan manager (baselines)
5- init parameter
https://docs.oracle.com/database/121/TGSQL/tgsql_influence.htm#TGSQL246
A,D,E
Init parameter (A)
Fixed Baseline (E) https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL618
C is not true. Remember, cardinality is a fancy word for “number of rows returned” by a SQL operation.
http://www.dba-oracle.com/t_sql_tuning_cardinality_plan.htm
A D E