Re: tkprof output?

From: <ronr_at_my-dejanews.com>
Date: Thu, 23 Jul 1998 14:13:29 GMT
Message-ID: <6p7gea$nul$1@nnrp1.dejanews.com>

In article <6p3mkq$r5o$1_at_sloth.swcp.com>, elufker_at_swcp.com (Ed Lufker) wrote:
> 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)
> eddie lufker

Did you analyze the database (dbms_utillity.analyze_schema ('x','COMPUTE|ESTIMATE') ?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 23 1998 - 09:13:29 CDT