Hi

is alter session set optimzer_goal same as alter session set optimizer_mode?

also, there are 4 optimizer modes

rule
choose
all_rows
first_rows

I read from a book that by default oracle uses choose and first_rows, is this true?

Finally does all_rows and first_rows use table statistics? Or only choose use it. (from oracle reference guide it seems that only choose uses it though)

thank you