On Friday 06 September 2002 19:13, you wrote: > 2. Commit time - The time for a 'commit' to occur is more a function of the > number of changes (i.e. table data + each index entry) than the amount of > data currently in the table/index.
More data in the index means a greater chance on getting index block splits (especially with small block sizes and large keys), and block splits and adding levels will generate more redo and have an effect on the commit time. Anjo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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).
