Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 4497 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
The Optimizer chooses Cost_based approach and optimizes with
the goal of best throughput if statistics for atleast one of
the tables accessed by the SQL statement exist in the data
dictionary. Otherwise the OPTIMIZER chooses RULE_based
approach.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are transaction isolation levels supported by oracle?
How to connect to a remote server?
How to export your connection information to a file?
What is the difference between post-database commit and post-form commit?
What is execute immediate in oracle?
What is a trigger and what are its types?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Explain the difference between a procedure and a function? What do you understand by those terms?
how can we store any pdf file in oracle
Explain do view contain data?
How do I escape a reserved word in oracle?
What are the types of partitions in oracle?
What are the restrictions on external table columns?
How to resolve the ORA-39133 error in Oracle?
Is rowid unique in oracle?
