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.

Does rowid change in oracle?

1 Answers  

---

How to convert characters to dates in oracle?

0 Answers  

---

How many file formats are supported to export data?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

Does a Before form trigger fire when the parameter form is suppressed ?

1 Answers   Oracle,

---

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

What is redo log?

0 Answers  

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---

What is the difference between post-database commit and post-form commit?

0 Answers  

---

When do you get a .pll extension in oracle? Explain its importance

0 Answers  

---

Can we write insert statement in function in oracle?

0 Answers  

---

What exactly do quotation marks around the table name do?

0 Answers  

---