which is fast and good output

From: oracle dba <aoracledba_at_gmail.com>
Date: 14 Dec 2006 01:46:14 -0800
Message-ID: <1166089574.593319.31240@t46g2000cwa.googlegroups.com>

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 |

---

Received on Thu Dec 14 2006 - 03:46:14 CST