Re: Inserts and db file sequential reads
From: William Robertson <williamr2019_at_googlemail.com>
Date: Sun, 4 May 2008 01:11:47 -0700 (PDT)
Message-ID: <6c24a3aa-971b-4aa0-96e7-a26862d8595a@y38g2000hsy.googlegroups.com>
Date: Sun, 4 May 2008 01:11:47 -0700 (PDT)
Message-ID: <6c24a3aa-971b-4aa0-96e7-a26862d8595a@y38g2000hsy.googlegroups.com>
On May 2, 11:52 pm, oracleing..._at_yahoo.com wrote:
> INSERT /*+ append */ INTO OPERATION_DTLS
> VALUES
INSERT /*+ APPEND */ is only applicable to INSERT SELECT, not INSERT
VALUES. Just as well, as each INSERT /*+ APPEND */ uses new blocks
above the high water mark rather than looking for space in existing
blocks, so unless each row uses exactly one block it could waste a
load of space.
Received on Sun May 04 2008 - 03:11:47 CDT