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