Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4809 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between translate and replace?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is procedure overloading in oracle?
How to start an oracle instance?
What is oracle update statement with inner join ?
Explain compound trigger in oracle?
6. Display the client name and order date for all orders using the traditional method.
How to delete all rows a table in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
What is object data modeling?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to use windows user to connect to the server?
What is a sub query and what are the different types of subqueries?
Explain how are indexes update?
How to rebuild an index in oracle?
