When searching all the possible paths of executing a query, the optimizer
finds and saves the cheapest paths for the top level rel. I'd like to check
out all the paths the optimizer has ever considered, which I believe, are
stored in the pathlist of the top level rel. But I do not have an idea of
how to "print out" these paths to see them visually. Does anyone have an
idea how I can achieve this?
Thanks,
Zhan