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 ?
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
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.