Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2013

    Unanswered: How db2 cost derive

    Hi Everyone,
    ever wonder how db2 database runstats cost derive from ?
    if there any formula to calculate the cost ?

    What's different from db2 and oracle cost ?

    How's this cost influence sql query.


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    infocenter or performance guide does explain the optimizer and related syntax
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    May 2003
    DB2 was the first database with a cost base optimizer. It estimated the "relative" cost of all accesses options, and chose the one with lowest cost. Most other database products such as Oracle have used a "heuristic" optimizer, although they have improved their product recently to add more cost based optimization. You can google "cost based optimizer" and "heuristic optimizer" to probably get more info on this.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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