Query Explain Tables Directly

[mike_dba]

I am trying to determine which tables in my database are being joined
and by what columns. I then came up with a query against
EXPLAIN_PREDICATE that returns rows similar to the following:

(Q1.PERIOD_KEY = Q2.PERIOD_KEY)

My problem is tying this Q1 & Q2 back to a tablename? Does anyone
know how this may be done? Or perhaps a suggestion on how better to
obtain this information.

Thanks in advance for your ideas!

[Pierre Saint-Jacques]

You'll need to investigate the column defs. of the other explain tables.
For each query explained, the facility will identify each table name
(MYTBL1, MYTBL2, HISTBL3, ...) in the query and the query graph model in the
query rewrite will rename those tables as Q1.MYTBL2, Q2.HISTBL3,Q3.MYTBL1.
I think the Q1, Q2, Q3 specifies the order in which the tables are accessed.
The EXPLAIN_OBJECT table may have the relationship between HISTBL3 and
Q2.HISTBL3 but I'm not sure.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"mike_dba" <mi*************@yahoo.coma écrit dans le message de news:
11*********************@j27g2000cwj.googlegroups.c om...

>I am trying to determine which tables in my database are being joined
and by what columns. I then came up with a query against
EXPLAIN_PREDICATE that returns rows similar to the following:

(Q1.PERIOD_KEY = Q2.PERIOD_KEY)

My problem is tying this Q1 & Q2 back to a tablename? Does anyone
know how this may be done? Or perhaps a suggestion on how better to
obtain this information.

Thanks in advance for your ideas!