what is the difference between the Explain Plan and SQL trace????
SQL Trace gives you more information than explain plan. It's especially useful when you want to get plan information for batch processes or stored procedures since you can dump out the whole process in one go, rather than picking out individual DML and explaining it.
The only point of note is you must run a statement to get an SQL trace. The explain plan does not require the statement to be run.
Last edited by TimHall; 12-13-2011 at 05:02 AM.
Click Here to Expand Forum to Full Width