Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    33

    Unhappy Unanswered: Multi_table join

    We have a db2 schema with 50 odd tables . of which
    One set of tables (TypA) are indexed and cluster with C1 column data. Similarily we have another set (TypB) with clustering of A1.
    There is another big table with TypC with index I1.. not directly related to the other two sets.

    When involved in a cursor of multi_table join, the performance is bad
    TypC table is driving the I/O waits crazy, i think its because of the Random access for the records.

    This is forcing us to do the query in two parts, one join and one simple select on TypC. We tried to use order by the column which is used to join TypC.

    Any suggestions for getting the query in one join with resonable performance is greatly appreciated.
    bs

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to post the table and index DDL, and the SQL query with the join.
    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
  •