Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4820 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 |
Can group functions be mixed with non-group selection fields?
Difference between cartesian join and cross join?
What a SELECT FOR UPDATE cursor represent.?
Which is better Oracle or MS SQL? Why?
What are triggers in oracle?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
What is a proxy object?
How can we view last record added to a table?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the difference between SQL and SQL Server?
What is a Shared SQL pool ?
What is dictionary cache ?
Oracle General 
