is index better option here

From: peter <hhh.database_at_gmail.com>
Date: 13 Dec 2006 00:14:25 -0800
Message-ID: <1165997665.711174.268170@l12g2000cwl.googlegroups.com>

before index output of explain is

SQL> @?\rdbms\admin\utlxplp.sql

PLAN_TABLE_OUTPUT

---

---

| Id | Operation | Name | Rows | Bytes | Cost |

---

|   0 | SELECT STATEMENT     |             |     1 |    40 |     5 |


|*  1 |  TABLE ACCESS FULL   | N           |     1 |    40 |     5 |

|*  2 |   TABLE ACCESS FULL  | N           |     1 |    15 |     5 |

|*  3 |   TABLE ACCESS FULL  | N           |     1 |    15 |     5 |

--------------------------------------------------------------------
********************************************************************

after index output of explain is

SQL> @?\rdbms\admin\utlxplp.sql

PLAN_TABLE_OUTPUT

---

---

| Id  | Operation                    |  Name       | Rows  | Bytes |

Cost |

---

| 0 | SELECT STATEMENT | | 1 | 40 |  5 |
|* 1 | TABLE ACCESS FULL | N | 1 | 40 |
 5 |
|* 2 | TABLE ACCESS BY INDEX ROWID| N | 1 | 15 |
27 |
|* 3 | INDEX RANGE SCAN | IND_N_CC | 144 | |
 1 |
|* 4 | TABLE ACCESS BY INDEX ROWID| N | 1 | 15 |
27 |
|* 5 | INDEX RANGE SCAN | IND_N_CC | 144 | |
 1 |

---

Received on Wed Dec 13 2006 - 02:14:25 CST