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

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

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.

Answer / mkjmkumar

CBO Evaluates the cost of available execution paths and
selects the execution path that has lowest relative cost.

Answer / nishi

oracle generate the execution plan to the available statistics.

when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers  

---

what is null value?

9 Answers  

---

What is an oracle wallet?

0 Answers  

---

what is main def between plsql/table and array?

1 Answers   Oracle,

---

Explain self joins in oracle?

0 Answers  

---

---

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 Answers   Wipro,

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

0 Answers   TCS,

---

What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers  

---

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,

---

What is the database name in oracle?

0 Answers  

---

How to start your 10g xe server from command line?

0 Answers  

---

can a view be updated?

3 Answers  

---