explain plan and sql ?

Is it possible to look at an explain plan and match the steps to the joins in the SQL statement?
for example:
a join where a.col1 = b.col1
would have a step in the explain plan for a nested-loop join

I think Quest will show you, but I'm curious how they are able to map it out, so maybe the question is how do they do it.

thanks,
steve Received on Sun Feb 11 2001 - 23:46:19 CST