Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3530 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
why pl sql doesn't support retrieving multiple records
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What do you mean by cdb and pdb in oracle 12c?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
hai, when to use char and varchar2....?
What are internal user account in oracle?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Why do we use coalesce function in oracle?
what is insert all statement in sql
What is oracle server autotrace in oracle?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
Oracle General 
