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 do you store pictures in a database?

0 Answers  

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

What is null value in oracle?

0 Answers  

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

0 Answers   GTL,

State the difference between a primary key and foreign key?

0 Answers  

Explain a data segment?

0 Answers  

What types of joins are used in writing subqueries?

0 Answers  

What do you know about normalization? Explain in detail?

0 Answers  

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

What is the meaning of recursive hints in oracle?

0 Answers  

When does a Transaction end ?

2 Answers  

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers