Re: Session optimizer goal and PLSQL

From: Andrew <ABryndin_at_retailpro.com>
Date: 15 Jun 2001 12:05:05 -0700
Message-ID: <2bfebe60.0106151105.216cbae5@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message >
> Question: did you use explain= on the tkprof command line.
> If so, tkprof will calculate *new* execution plans, not necessarily those in
> the trace file. To see those, do not use explain=
>

Yes I use explain= on tkprof, how can I check explain plan otherwise, but if it generates new executaion plan how it becomes "first_rows" then if database instance goal is just "choose". Received on Fri Jun 15 2001 - 14:05:05 CDT