Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4652 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 |
When do I need to use a semicolon vs a slash in oracle sql?
How would you change old and new values in an insert, delete and update triggers?
How to connect asp pages to oracle servers?
How to manage transaction isolation level?
how to retrive xml data for using sql query?
State all possible different index configurations a table can possibly have?
How to use regular expression in pattern match conditions in oracle?
how can we write trigger in trigger???????? can we write one trigger on two table???
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
How to define a cusotmer as a supplier in ORACLE R12
Oracle General 
