DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: re: need expert advice on UPDATE statements

  1. #1
    Join Date
    Jan 2004
    Posts
    58

    re: need expert advice on UPDATE statements

    hi! ,

    Here are my system config ..

    1GB RAM
    Oracle 8.17 (Database )
    Windows 2000 Professional (OS)
    P4 1.7 Ghz

    I am creating tables and indexes on them ...

    Using the info from the tables I am creating a new table with 40
    columns. I am updating the columns in the new table with data
    uploaded into the tables created previously.

    It is taking a very long time to update the records in the new table.
    The new table has about 500 thousand records.

    Can anybody advise on how to decrease the processing time as much as
    possible ..??
    What is the oracle procedure of doing updates ?
    What are the thing to be aware of while doing updates ?
    How do I tune the process ( from DBA side and/or developer side )
    to drastically reduce the processing time ?
    Any changes to the parameter file ?
    etc ..

    thanks very much ..
    in the least a dialogue also would be appreciated ...
    thanks,
    harish

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    What are the queries you use to upload the data? Is it a heavy update? if it is batch update, you better drop the indexes created on update columns..
    -nagarjuna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width