Dear list, In a 9.2 trace file, there is two sections titled "row source operation" and "execution plan" after the SQL stmt. Sometime they showed the same plan but other times they are different. I am wondering what the plan under "row source operation" mean and why they can be different. Thanks Jos --------------------------------- Find local movie times and trailers on Yahoo! Movies. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------