Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: LTQ, DTQ, GRPBY, NLJOIN in Optimizer Plan?

    What do LTQ, DTQ, GRPBY, NLJOIN in Optimizer Plan of explain stand for?

    Thanks
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    They are all explained in the DB2 Information Centre - all you need is search for them.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

  4. #4
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    thanks.

    And what is LTQ and DTQ (they are not there)?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by MarkhamDBA
    thanks.

    And what is LTQ and DTQ (they are not there)?
    Try using the search to locate them from the starting point I gave you.

    Andy

  6. #6
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by ARWinner
    Try using the search to locate them from the starting point I gave you.

    Andy
    got it. Thank you

    I could not find them before because I was looking in InfoCentre for DB2 v8 (we are using DB2 v8.2 yet).
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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