Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    34

    Unanswered: Find foreign keys without index

    I am on DB2 on z/OS .
    Found out some very slow running delete on a parent table
    as the child table didn't have an index for the fk cols .
    Does anyone have a query to find out all fkeys without an index ?

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Looks at the catalog tables such as SYSFORIGNKEYS, SYSKEYS and SYSINDEXES.

Posting Permissions

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