Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> tuning an simple insert-statement

tuning an simple insert-statement

From: Pascal Ziegler <pascal.ziegler_at_bluewin.ch>
Date: Sat, 06 Sep 2003 09:50:58 +0200
Message-ID: <3f5991a9$1@news.swissonline.ch>


hi,

i have to insert several values with a simple insert-statement.

e.g.

INSERT INTO xy VALUES (1, 2, 3, 4); -- really simple ;-)

(the table has just a primary-key index!!)

i did this with oracle 9i and cache from intersystem! cache was about 5 times faster than oracle!! is this just the way it is or can i improve the performance of oracle!?? and how?

thanks
- pascal Received on Sat Sep 06 2003 - 02:50:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US