Interested to Buy Any Domain ? << Click Here >> for more details...
Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3975 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Presence of statistics in the data dictionary for atleast
one of the tables accessed by the SQL statements is
necessary for the OPTIMIZER to use COST-based approach.
Otherwise OPTIMIZER chooses RULE-based approach.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
why dont we assign not null constraint as table level constraint.
What is an oracle data file?
How to end the current transaction in oracle?
how may join possible between (requisition with purchase order)
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to use existing values in update statements using oracle?
How many memory layers are in the oracle shared pool?
What is an oracle tablespace?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to initialize variables with default values?
How to view the data files in the current database?
What is snapshot is too old? Give and example for better understand.
How to build data dictionary view an new database?
How to divide query output into groups in oracle?
