Link to home
Start Free TrialLog in
Avatar of walkerdba
walkerdba

asked on

cbo optimer

In a simple way what is the meaning of cost base optimizer..
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

It is code that uses statistics to choose the best execution plan for whatever the task is.

The old way was rule based.  It had strict rules to follow.  For example, if an index exists, use it no matter what.

The problem here is at times using an index will actually slow down the execution.

See if this helps fill in the gaps:
http://www.dba-oracle.com/art_otn_cbo.htm
Hi walker, for every statement, the Oracle system will attempt to optimize the execution cost.  As slight mentioned, statistics provide the metadata used to evaluate the size and distribution of data.

Is that simple enough? <grins>
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Let me see if i can provide any inputs here.

In a simple way what is the meaning of cost base optimizer..
  => when we go to a market to buy something, we choose a product of low cost(ofcourse, not compromising on the quality).
  => Similarly, Oracle calculates the cost(for each unit of operation viz. performing a full table scan/index unique scan/range scan etc., )and gives us each step in the execution plan and the the cost associated with it.

Just my 2 cents.
Avatar of walkerdba

ASKER

yes