On Wednesday 04 September 2002 04:23, [EMAIL PROTECTED] wrote: > It sounds to me like the indexes are going into overflow - this will cause
What do you mean by 'overflow'? Jared > the insert time to increase. I would suggest batching up the inserts, > dropping the indexes, running the inserts and re-creating the indexes. > > Chris > > -----Original Message----- > Sent: 04 September 2002 07:53 > To: Multiple recipients of list ORACLE-L > > > Hi All, > > We have a table which can contain more than half a million records. When we > try to insert some 10k records in the empty table it get inserted in 10 > min. but as the size increases time taken to insert also increases. After > 350,000 records it takes around an hour to insert 10k records. > There are around 15 columns in it out of which 11 are indexed. There is one > concatenated function-based index on two columns of Varchar type and two > separate index for the same two columns. > > I have checked the free space for the tablespaces to which the table and > indexes are attached to. They are in two separate tbs. > > Any clues why this is happenning. > > TIA > Marul. ---------------------------------------- Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).