RE: [suse-oracle] Cost in Plan Table

From: Christian Antognini (Christian.Antognini@trivadis.com)
Date: Fri Oct 04 2002 - 14:23:14 CEST

  • Next message: Paul Gilligan: "Re: [suse-oracle] Cost in Plan Table" 
    Date: Fri, 4 Oct 2002 14:23:14 +0200
Message-ID: <2CF83791A616BB4DA203FFD13007824ABC15C8@MSXVS02.trivadis.com>
From: "Christian Antognini" <Christian.Antognini@trivadis.com>
Subject: RE: [suse-oracle] Cost in Plan Table

    If the optimizer is CHOOSE you must have the optimizer statistics to
    enable the CBO. Did you gather the statistics via ANALYZE or DBMS_STATS?

    > -----Original Message-----
    > From: Rajiv Khatri [mailto:rajiv.khatri@patni.com]
    > Sent: 04 October 2002 14:20
    > To: Christian Antognini; 'suse oracle list'
    > Subject: RE: [suse-oracle] Cost in Plan Table
    >
    > Hi Chris
    >
    > I have also checked the optimizer in both the situation it is Choose
    only.
    > Raj
    >
    > -----Original Message-----
    > From: Christian Antognini [mailto:Christian.Antognini@trivadis.com]
    > Sent: Friday, October 04, 2002 5:39 PM
    > To: rajiv.khatri@patni.com; suse oracle list
    > Subject: RE: [suse-oracle] Cost in Plan Table
    >
    >
    > Hi Rajiv
    >
    > Probably without hint your query is optimized by the RBO. Therefore no
    > cost is computed. Adding hints to a query allways "force" the CBO...
    > except for the hint RULE ;-)
    >
    > Chris
    >
    > > -----Original Message-----
    > > From: Rajiv Khatri [mailto:rajiv.khatri@patni.com]
    > > Sent: 04 October 2002 14:08
    > > To: 'suse oracle list'
    > > Subject: [suse-oracle] Cost in Plan Table
    > >
    > > Hi
    > >
    > > When I run query with hint it shows me the cost = 4 in plan table.
    > > But when i run the same query without hint the cost is NULL in the
    > plan
    > > table.
    > >
    > > I want to see the cost for the query without hint. How to do ?
    > >
    > > Oracle 8i. (8.1.7)
    > > NT 4.0
    > >
    > > Rajiv
    > >
    > >
    > >
    > >
    > >
    ---------------------------------------------------------------------
    > > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > > For additional commands, e-mail: suse-oracle-help@suse.com
    > > Please see http://www.suse.com/oracle/ before posting
    >
    >
    > ---------------------------------------------------------------------
    > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > For additional commands, e-mail: suse-oracle-help@suse.com
    > Please see http://www.suse.com/oracle/ before posting

    ---------------------------------------------------------------------
    To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    For additional commands, e-mail: suse-oracle-help@suse.com
    Please see http://www.suse.com/oracle/ before posting

    This archive was generated by hypermail 2.1.4 : Fri Oct 04 2002 - 14:23:32 CEST