|
-
select * from v$parameter where name = 'optimizer_mode'
Check the value column. It will be either Rule, Cost or Choose.
Rule and Cost speak for themselves.
Choose (the default value) will use the Cost Based Optmizer when at least one of the objects in the query has statistics gathered for it. Otherwise the rule based optimizer is used.
HTH
David.
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
|