Oracle 7.3.4, OpenVMS 7.1
My tkprof report is missing the row count in the execution plan. Does
anyone know why what I might be missing?
If I autotrace the same query in the same database, I do get cardinality.
The tables have been analyzed.
If I tkprof another database using the same version and OS, that tkprof DOES
have row counts.
I believe I'm just missing a parameter somewhere, but I don't know where.
Thanks for any ideas.
Barb
$ tkprof DRAX02_AMPROD_FG_SRV_041.TRC;1 sel.tkp explain=user/pwd
sys=no
*********************************************************************
***********
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
0 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF 'WO'
0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'PK_WO' (UNIQUE)
****************************************************************************
****
here's a tkprof from a different database:
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
1440212 SORT (GROUP BY)
2785044 HASH JOIN
3109095 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF
'WORK_ORDER_DETAILS'
3762491 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'WORK_ORDER_DETAILS_IDX3' (NON-UNIQUE)
5727880 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'SLS_OF_REC'
****************************************************************************
****
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
<<winmail.dat>>
