Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4657 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 |
How to start a specific oracle instance?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
how to get last monday of a month?
6. Display the client name and order date for all orders using the traditional method.
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
what is the use of composite key constraint?
Give the different types of rollback segments.
What are the predefined tablespaces in a database?
write a query that displays every Friday in a year with date?
What does a Control file Contain ?
How to add a new column to an existing table in oracle?
Oracle General 
