Interested to Buy Any Domain ? << Click Here >> for more details...
What is COST-based approach to optimization ?
- 5 Answers
- 8856 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahesh
For running any quey requires or generates an execution pan
before actually fetching data
in cost based approach, the oracle will generates the
execution plan based on available statistics.
oracle supports cost based approcach and it is continuously
improving fron one version to another version of oralce
database
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mkjmkumar
Oracle Analyse a Query using two Approches
1. CBO
2. RBO
Cost Based Analyser is default when we do not in oracle
setup.
CBO picks up query output using witch have less cost
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / tony
Cost Based Optimizer (CBO) - This method is used if
internal statistics are present. The CBO checks several
possible execution plans and selects the one with the
lowest cost, where cost relates to system resources.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mkjmkumar
CBO Evaluates the cost of available execution paths and
selects the execution path that has lowest relative cost.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nishi
oracle generate the execution plan to the available statistics.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the database name in oracle?
What happens to indexes if you drop a table?
What are transaction isolation levels supported by oracle?
Does oracle charge for java?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
What is the difference between online and offline backups?
How to create a temporary table in oracle?
What is oracle latest version?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
> 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 many memory layers are in the shared pool?
What is a procedure in oracle?
Oracle General 
