Results 1 to 2 of 2

Thread: Question SQL

  1. #1
    Join Date
    Dec 2002
    Madrid - Spain
    Provided Answers: 1

    Unanswered: Question SQL

    Hi colleagues,
    I have this query.
    select * from table where field = ? and field1 = ? and field2 = ?

    I need to analize this query with
    db2expln -d bbdd -g -i -z \; -f query.sql -t

    can someone tell me which values ​​replace question marks (?)

    Thank you for advanced.
    DBA DB2 for LUW

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    When parameter markers are used, DB2 optimizer assumes a normal distribution for that column.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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