-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|