Thanks for the tip. Does _IDXFILE_LIST_SIZE affect the performance of inserts into a table with indexes on it, or it purely used for create index statement only?
On Mon, 2002-04-08 at 22:43, Zabach, Elke wrote: > Mark Wong wrote: > > > Does anyone have any tips for tuning the performance of creating an > > index on a table with data already in it? > > > As Holger wrote 3 months ago: > > >To increase index creation performance you could check some database > parameters. > > 1. DATA_CACHE should be as big as possible to minimize disk I/O. > > 2. Increase the parameter _IDXFILE_LIST_SIZE. > Possible values are 0 (=Off), 128, 256, 512, 1024, 2048, 4096, 8192. > This parameter influences the create index algorithm. It defines the maximum > > number of temporary buffers used for the merge algorithm. A larger number of > > buffers decreases the number of merge steps, and thus increases performance. > > But DATE_CACHE must be at least three times larger than _IDXFILE_LIST_SIZE. > > 3. Spread your database over several disks to increase performance by > parallel I/O. > > You can set database parameters via dbmgui or dbmcli. > > HTH, > Holger > > SAP Labs Berlin< > > Elke > SAP Labs Berlin > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general -- Mark Wong - - [EMAIL PROTECTED] Open Source Development Lab Inc - A non-profit corporation 15275 SW Koll Parkway - Suite H - Beaverton OR, 97006 (503)-626-2455 x 32 (office) (503)-626-2436 (fax) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
