Message-Id: <10701.123641@fatcity.com> From: =?iso-8859-1?q?paquette=20stephane?= Date: Tue, 5 Dec 2000 05:03:52 -0800 (PST) Subject: Insert /*+append */ takes more time than insert 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@yahoo.com __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/