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.

How to create lov dynamically at runtime & attach to text field?

0 Answers  

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 Answers  

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

does Oracle has only one table space?

1 Answers   Oracle,

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

Explain view?

0 Answers  

How can we Update a table with out using UPDATE command?

1 Answers  

What is a public synonym?

1 Answers  

What is the difference between substr & instr functions?

0 Answers  

What are the advantages of oracle?

0 Answers  

What is a lookup table in oracle?

0 Answers  

How to work with data objects interactively?

0 Answers