Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4397 Views
- I also Faced
- E-Mail Answers
Answer / guest
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 |
Explain about achiever in sql?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
What are steps required to ENTER DATA INTO DWH?
Why we use bulk collect in oracle?
How do I escape a reserved word in oracle?
how to retrive xml data for using sql query?
26. Display the earliest shipping date in the format: DD/MON/YYYY
What are the predefined tablespaces in a database?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What are the various oracle database objects?
What are the common oracle dba tasks?
Oracle General 
