Interested to Buy Any Domain ? << Click Here >> for more details...
What is COST-based approach to optimization ?
- 5 Answers
- 8843 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 |
Can Multiple instances be run on Single Machine???
How to omit columns with default values in insert statement in oracle?
what is the difference between sql& oracle?
How to rename a column in an existing table?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
What are data pump export and import modes?
how do u know the total no of rows in a table?
What is OCI. What are its uses?
What are the limitations oracle database 10g xe?
difference between bind variable and variable
Is oracle a programming language?
How to count groups returned with the group by clause in oracle?
Oracle General 
