Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4568 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What happens to the current transaction if the session is ended?
Name the various constraints used in oracle?
What are the oracle built-in data types?
Can multiple cursors being opened at the same time?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to initialize variables with default values?
How to define default values for formal parameters?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is the difference between a primary key & a unique key?
State all possible different index configurations a table can possibly have?
What is index-organized table in Oracle?
Explain rename?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is PL/SQL ?
