RE: tkprof & explain question

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <sjaffarhussain@xxxxxxxxx>
  • Date: Sat, 21 May 2005 14:08:59 +0200


>However,  my question is, when I am using
>tkprof with explain parameter, if there are any insert,update or
>delete statements in my trace file, are they going execute or just
>produces explain plan wihtout executing them?

TKPROF executes an EXPLAIN PLAN statement, not the DDL statement.

Be careful that EXPLAIN PLAN can return a "wrong" execution plan, i.e. =
not the execution plan that was executed and generated all other =
statistics the you see in the TKPROF output.



Other related posts: