Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: Inserts and...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 4 Topic 16499 of 17118
Post > Topic >>

Re: Inserts and db file sequential reads

by William Robertson <williamr2019@[EMAIL PROTECTED] > May 4, 2008 at 01:11 AM

On May 2, 11:52 pm, oracleing...@[EMAIL PROTECTED]
 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.
 




 4 Posts in Topic:
Inserts and db file sequential reads
oracleingres@[EMAIL PROTE  2008-05-02 15:52:55 
Re: Inserts and db file sequential reads
"Jonathan Lewis"  2008-05-03 10:17:33 
Re: Inserts and db file sequential reads
William Robertson <wil  2008-05-04 01:11:47 
Re: Inserts and db file sequential reads
"Jonathan Lewis"  2008-05-04 09:38:18 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Aug 29 18:14:27 CDT 2008.