Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: What is unit of time for "estimate Cost" in db2expln tool in db2v7.2?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    86

    Re: What is unit of time for "estimate Cost" in db2expln tool in db2v7.2?

    Originally posted by David2002

    Thanks
    for example:

    Section = 3


    SQL Statement:

    INSERT INTO ba_Address (Address_COID , Apart_Number , City_ ,
    Country_Code , Country_ , Line1_ , Line2_ , Postal_Code ,
    Region_Code , Region_ , Lock_Key , TD_Cust_Link ) VALUES
    (:H00001 , :H00002 , :H00003 , :H00004 , :H00005 , :H00006 ,
    :H00007 , :H00008 , :H00009 , :H00010 , :H00011 , :H00012 )

    Intra-Partition Parallelism Degree = 0

    Estimated Cost = 25
    Estimated Cardinality = 1

    Insert: Table Name = DBA.BA_ADDRESS ID = 2,11

    End of section


    Optimizer Plan:

    INSERT
    ( 2)
    |
    Table:
    DBA
    BA_ADDRESS

    Estimate Cost is 25 SEC or miliSEC or ......

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: What is unit of time for "estimate Cost" in db2expln tool in db2v7.2?

    mmm ... It is 'timerons'

    Defn of timeron :

    A timeron is a unit of measurement used to give a rough relative estimate of the resources, or cost, required by the database server to execute two plans for the same query. The resources calculated in the estimate include weighted CPU and I/O costs.

    OR

    A timeron is an abstract unit of measure. It does not directly equate to any actual elapsed time, but gives a rough relative estimate of the resources (cost) required by the database manager to execute an access plan.



    Originally posted by David2002
    Thanks

  4. #4
    Join Date
    Jul 2002
    Posts
    86

    Re: What is unit of time for "estimate Cost" in db2expln tool in db2v7.2?

    Originally posted by sathyaram_s
    mmm ... It is 'timerons'

    Defn of timeron :

    A timeron is a unit of measurement used to give a rough relative estimate of the resources, or cost, required by the database server to execute two plans for the same query. The resources calculated in the estimate include weighted CPU and I/O costs.

    OR

    A timeron is an abstract unit of measure. It does not directly equate to any actual elapsed time, but gives a rough relative estimate of the resources (cost) required by the database manager to execute an access plan.
    Thank you so much for your reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •