What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 3616 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a proxy class?
What is the difference between post-database commit and post-form commit?
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.
Can we call procedure inside function in oracle?
What is a trigger and what are its types in oracle?
Why do we use coalesce function in oracle?
How to turn on or off recycle bin for the session?
How will you differentiate between varchar & varchar2?
What is the difference between primary key and unique key and foreign key in oracle?
List the types of joins used in writing subqueries?
What is an oracle user account?
What is the relation of a user account and a schema in oracle?
what are the default admin accounts in Oracle 10g ?
Explain the features of oracle?
What is oracle open database communication (odbc)?
