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
- 4397 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
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
How to enter a new row into a table interactively?
How to connect the oracle server as sysdba?
How is it different from a normal table?
How to drop a tablespace?
Explain parameter file in oracle.
How to call a sub procedure?
Explain the use of show option in imp command.
Explain the use of full option in exp command.
How to export data to a csv file?
Explain integrity constraints?
Explain an index segment?
What is blob datatype?
Explain what are the characteristics of data files?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What are the advantages of oracle 12c?
