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
- 4468 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 |
What is difference between SUBSTR and INSTR?
What is an Oracle index?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What WHERE CURRENT OF clause does in a cursor?
Explain the use of grant option in imp command.
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
What is the difference between translate and replace?
What is a oracle database?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
How to convert a date to char in oracle? Give one example.
What happens if recursive calls get out of control?
What is blob datatype?
Oracle General 
