Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    42

    Unanswered: optimizer on <> predicate

    DB2 9.7

    Can db2 use index on the following predicate:

    code <> 'xxxxxx'

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't know, but if you can't get it to work, try these:

    code < 'xxxxxx' and code > 'xxxxxx'

    code < 'xxxxxx'
    UNION ALL
    code > 'xxxxxx'
    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
  •