Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4712 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
List the parts of a database trigger.
What is oracle join syntax?
types of indexes and the rationale behind choosing a particular index for a situation.
What happens to the current transaction if the session is killed?
What is the relation of a user account and a schema in oracle?
Where do we use decode and case statements?
what is the difference between first normal form & second normal form?
What are dml statements in oracle?
How can we find out the current date and time in oracle?
What is an oracle?
What are the major difference between truncate and delete?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Oracle General 
