RE: Optimization of insert and update

From: William Rogge <William_Rogge_at_voltek.com>
Date: Thu, 11 Jan 2001 10:20:24 -0500
Message-Id: <10738.126396@fatcity.com>

My first suggestion would be to write a function to perform the bulk update. You can code it with a decode of the column name to update. Then you can call it with the column and new value as parameters. One coding, multiple usage's, clean, easy.

Insert statements can't really be optimized since the server will find the place to insert them by itself. The only real place you can save anything is if there are a lo5t of indexes that must be updated during the insert.  Depending on the number of inserts, it may be quicker to drop the indexes, insert the rows, then recreate the indexes.

-----Original Message-----

From:	bipin sahani [SMTP:bipinsahani_at_yahoo.co.in]
Sent:	Wednesday, January 10, 2001 11:46 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Optimisation of insert and update

Hi All,
I've following queries regarding oracle insert and update

1)Is there any way I can optimise my insert statemnts 2)I want to update multiple rows based on same condition in oracle 7.1.6

For e.g update taba set b='XYZ' whare c='ABC'

        update taba set b='PQR' where c='LMN' and so forth.
And no of columns which will be getting updated daily is not also constant .One day 10 columns will get updated Next day 25000 will get updated. Is there any way to speed up this process.Or I'll have to call SQL everytime for each update 3)What's maximum length of SQL query I can write  in ORACLE 7.1.6.And what are the factors on which it depends.
Thankx in advance
Regards
Bipin

---

Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?bipin=20sahani?=
  INET: bipinsahani_at_yahoo.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 11 2001 - 09:20:24 CST