Mark Wong wrote: > > 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?
It's only used during CREATE INDEX. No effect for insert/update/delete of rows of tables on which an index is defined. Elke SAP Labs Berlin > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
