Need support on tuning at the time of index creation

to create 29 indexes includung primary key index and other types of indexes. Currently it is taking almost 3.5 to 4 hrs. Please let us know how we can tune the perfirmance so that we can complete this task in 30-40 mins. Note: We cannot change the db version. Thanks & Regards, Sandip Pradhan

RE: Need support on tuning at the time of index creation

Hi Ron, Thanks for your time. We are using the version 9.5.9.14. Regards,   Sandip Pradhan Tech Lead   BDGS SD IN BSS EOC_ECM 1 Mobile: 9830880856 sandip.prad...@ericsson.com   Ericsson DLF IT Park - II, DLF SEZ Block 1A, Rajarhat 700156, Kolkata, West Bengal India ericsson.com

RE: Need support on tuning at the time of index creation

u need any further information. Regards,   Sandip Pradhan Tech Lead   BDGS SD IN BSS EOC_ECM 1 Mobile: 9830880856 sandip.prad...@ericsson.com   Ericsson DLF IT Park - II, DLF SEZ Block 1A, Rajarhat 700156, Kolkata, West Bengal India ericsson.com -Original Message- From: Peter J. Holzer Se

RE: Need support on tuning at the time of index creation

Currently maintenance_work_mem set to 25 GB. Regards, [cid:image002.png@01D5D84D.47F72BC0]<http://www.ericsson.com/> Sandip Pradhan Tech Lead BDGS SD IN BSS EOC_ECM 1 Mobile: 9830880856 sandip.prad...@ericsson.com<mailto:sandip.prad...@ericsson.com> Ericsson DLF IT Park - II, DLF