By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Query Explain Tables Directly

P: n/a
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!

Feb 8 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!
Feb 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.