Insert /*+append */ takes more time than insert

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Tue, 5 Dec 2000 05:03:52 -0800 (PST)
Message-Id: <10701.123641@fatcity.com>

Hi,

I'm testing aggregates creation on Oracle 8.1.6. I'm using insert as select, my testing shows that insert /*+ append */ always takes more time than insert .

Why ?

TIA

---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ Received on Tue Dec 05 2000 - 07:03:52 CST