Indexing on Catlog Tables

pankajsoni · New User Joined: 21 Jun 2006 Posts: 9 Location: Zurich

Hi all,

I have a small DB2 tool in Rexx and using the DSNREXX to connect with DB2.

This tool generates some catalog information in my desired format and have complex queries on DB2 catlog tables. But, unfortunately, I am not getting the good performance. There may be chance of improving my queries and that I would try to. But, I am just exploring the possibility of creating some indexes.

So, my questions are,
1) Can I create Indexes on Catlog Tables in any of my personal TABLESPACE ?
2) If yes, then How to make my query to use this Index in Rexx ?

stodolas · Posted: Mon Jul 30, 2007 1:42 am

1) You can only create an index on the tables in their own TABLESPACE as far as I know. Try it and find out.
2) DB2 determines if it wants to use an index for your query, not you. DB2 will optimize as best as possible using available indexes it find.