Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: How can I find which indexes in database use INCLUDE option?

    Hello every body,
    I work with db2 V7.2 fixpack6 AIX 4.3.

    Thank you in advance for your help

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It is in SYSCAT.INDEXCOLUSE. The catalog views are described in Appendix D of the SQL Reference.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Originally posted by Marcus_A
    It is in SYSCAT.INDEXCOLUSE. The catalog views are described in Appendix D of the SQL Reference.
    Thank you Marcus

Posting Permissions

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