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
