Re: ROWNUM & server performance

From: <srivenu_at_hotmail.com>
Date: 11 Nov 2005 11:52:24 -0800
Message-ID: <1131738744.920254.252560@o13g2000cwo.googlegroups.com>

This is one case where i found the cardinality shown to be funny. create table x as select rownum a from dba_users; analyze table x compute statistics;
insert into x values(1)
Execution Plan

---

   0 INSERT STATEMENT Optimizer=CHOOSE (Cost=2 Card=250 Bytes=750)

Xplan output

PLAN_TABLE_OUTPUT

---

---

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

---

| 0 | INSERT STATEMENT | | 250 | 750 | 2 |

---

regards
srivenu Received on Fri Nov 11 2005 - 13:52:24 CST