Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
The database has 578 columns and 2 column match is for an index which has 5 columns in it.
Are these 2 columns the first 2 columns named in the index?
But why do you think an inefficiancy in the sql query can cause pages retrieved from catalogues tables?
Rather an inefficient query can cause a high amout of temporary table usage. DB2 does use the db2 catalog for some "under the covers" work, but someone much more knowledgable than i am would have to provide details.
How many rows are in this table? How many rows are returned from a "high usage" query?
Have you or the dba run an explain on some of the problem queries to see what might be learned?