how can I use EXPLAIN tables for query access plan characteristics

M_RAS · #1 (**permalink**) 04-20-06, 15:24

Hi
I am working with db2v8.2.2 and aix 5.2

recently I encountered with performance issue in production after weekly maintenance (reorg, runstats and bind) it seems to me access plan for some packages has been changed.

I am thinking to query EXPLAIN tables before bind and after bind and retrieve the difference between to access plan. is it possible ? and how can I do that?any help is really appreciated.

przytula_guy · #2 (**permalink**) 04-21-06, 03:22

the plantable would be the best table to look for
access method is indicated - you could check if I (index) is used or table scan ....

M_RAS · #3 (**permalink**) 04-21-06, 08:33

Quote:

Originally Posted by przytula_guy

the plantable would be the best table to look for
access method is indicated - you could check if I (index) is used or table scan ....

Thank you przytula_guy for your response.

what is "plantable" I searched and I could not find the table, all table I can find is as follow:
EXPLAIN_ARGUMENT
EXPLAIN_INSTANCE
EXPLAIN_OBJECT
EXPLAIN_OPERATOR
EXPLAIN_PREDICATE
EXPLAIN_STATEMENT
EXPLAIN_STREAM

Internet Services

Web Development

Digital Marketing

Consumer Tech