Re: which is fast and good output

oracle dba schreef:
> Hello All,
>
> I am showing 2 explain plans, please tell me which is good and why.
>
> SQL> @?\rdbms\admin\utlxplp.sql
>
> PLAN_TABLE_OUTPUT
> -------------------------------------------------------------------------
>
> ------------------------------------------------------------------------
> | Id | Operation | Name | Rows | Bytes | Cost
> |
> ------------------------------------------------------------------------
> | 0 | SELECT STATEMENT | | 1 | 235 | 6
> |
> |* 1 | VIEW | | 1 | 235 | 6
> |
> |* 2 | WINDOW SORT PUSHED RANK| | 1 | 40 | 6
> |
> |* 3 | TABLE ACCESS FULL | N | 1 | 40 | 4
> |
> ------------------------------------------------------------------------
>
>
> SQL> @?\rdbms\admin\utlxplp.sql
>
> PLAN_TABLE_OUTPUT
> ----------------------------------------------------------------------
>
> --------------------------------------------------------------------
> | Id | Operation | Name | Rows | Bytes | Cost |
> --------------------------------------------------------------------
> | 0 | SELECT STATEMENT | | 1 | 40 | 4 |
> |* 1 | TABLE ACCESS FULL | N | 1 | 40 | 4 |
> |* 2 | TABLE ACCESS FULL | N | 1 | 15 | 4 |
> |* 3 | TABLE ACCESS FULL | N | 1 | 15 | 4 |
> --------------------------------------------------------------------
>

The mauve one.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...