D
danielb
Guest
We are needing to make an index change to the primary index on one of our largest tables. The current index is something similar to: index01 => fund, mem-ext, calculation-date, calculation-type and we need to change it to index01 => fund, mem-ext, calculation-type, calculation-date There are a few different options, and we are unsure what the impact is on replication, AI and database activity for the following: Just change the index. This results in a rename to temp, add new index, and drop the temp index. Add a new index (index04), and update the primary index. Leave the existing index there as active and renamed and zz-. Add a new index (index04), update the primary index, and deactivate the existing index. We're thinking of leading towards #2, maybe #3. Cheers
Continue reading...
Continue reading...