| SQL Tuning [message #99483] |
Thu, 29 November 2001 14:17  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
I am doing importing of records into a Oracle database and I'm having serious performance issues.
I have 45 SQL statements doing "Insert" per record. The most expensive SQL statement "Matching logic" is using a lot of overhead. Is there a way to optimize this import process?
The schema has 470 tables by the way.
Thanks
----------------------------------------------------------------------
|
|
|
|
| Re: SQL Tuning [message #99515 is a reply to message #99483] |
Wed, 19 December 2001 09:49  |
robert malikian
Messages: 18
Registered: October 2001
|
Junior Member |
|
|
Try dropping all indexes, then do the insert once finished re-create the indexes.
Robert
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
