Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Question Unanswered: Indexes on expressions of columns

    Hello,

    I have a DB2 v.9.5 on a AIX system.

    Does it support indexes on expressions of a column?

    For example something like this :
    CREATE INDEX ITEM_IDX ON ITEM
    (LOWER("ITEM_NAME"), ITEM_ID)

    Thanks in advance,

    Antony


  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No. Add a generated column and use it to create the index.

Posting Permissions

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