What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
Answer Posted / guest
This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
material view and view disadvantages?
master table and child table performances and comparisons in Oracle ?
What is the oracle implicit cursor?
Is there any function in oracle similar like group_concat of mysql?
20. Using a set operator, display the client number of all clients who have never placed an order.
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is a snapshot log?
What is analyze command used for?
What is the difference between Delete, Truncate and Drop in Oracle?
What are the limitations of check constraint?
State the various uses of dbcc command?
What are the ways tablespaces can be managed and how do they differ?
What is oracle datasource?
When do I need to use a semicolon vs a slash in oracle sql?
How to import one table back from a dump file?