tkprof output?

From: Ed Lufker <elufker_at_swcp.com>
Date: 22 Jul 1998 03:34:50 GMT
Message-ID: <6p3mkq$r5o$1@sloth.swcp.com>

Hi All:

What would cause no rows to show up under this execution plan the I pulled out of a tkprof output file?

Misses in library cache during parse: 0 Optimizer goal: RULE
Parsing user id: 224 (TA087)

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: RULE
      0   SORT (ORDER BY)
      0    NESTED LOOPS
      0     NESTED LOOPS (OUTER)
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        NESTED LOOPS (OUTER)
      0         NESTED LOOPS (OUTER)
      0          NESTED LOOPS
      0           TABLE ACCESS (BY ROWID) OF 'S_ORG_EXT'
      0            INDEX (RANGE SCAN) OF 'S_ORG_EXT_U1' (UNIQUE)
      0           TABLE ACCESS (BY ROWID) OF 'S_CONTACT'
      0            INDEX (RANGE SCAN) OF 'S_CONTACT_M2'
                       (NON-UNIQUE)
      0          TABLE ACCESS (BY ROWID) OF 'S_ADDR_ORG'
      0           INDEX (UNIQUE SCAN) OF 'S_ADDR_ORG_P1' (UNIQUE)
      0           INDEX (UNIQUE SCAN) OF 'S_ADDR_ORG_P1' (UNIQUE)
      0         TABLE ACCESS (BY ROWID) OF 'S_SRC'
      0          INDEX (UNIQUE SCAN) OF 'S_SRC_P1' (UNIQUE)
      0        TABLE ACCESS (BY ROWID) OF 'S_POSTN_CON'
      0         INDEX (RANGE SCAN) OF 'S_POSTN_CON_U1' (UNIQUE)
      0       TABLE ACCESS (BY ROWID) OF 'S_POSTN'
      0        INDEX (UNIQUE SCAN) OF 'S_POSTN_P1' (UNIQUE)
      0      TABLE ACCESS (BY ROWID) OF 'S_EMPLOYEE'
      0       INDEX (UNIQUE SCAN) OF 'S_EMPLOYEE_P1' (UNIQUE)
      0     TABLE ACCESS (BY ROWID) OF 'S_CAMP_CON'
      0      INDEX (RANGE SCAN) OF 'S_CAMP_CON_U1' (UNIQUE)

thanks
eddie lufker Received on Tue Jul 21 1998 - 22:34:50 CDT