Hi Guys
Apologies.
a)
1) SEARCH FOR SUBINDEX IN A OPTIMISED MERGED INDEX
2) DELETE THE FOUND SUBINDEX FROM THE OPTIMISED MERGERINDEX
3) OPTIMISE THE MERGERINDEX
4) ADD A NEW VERSION OF THE SUBINDEX TO THE MERGER INDEX
5) OPTIMISE THE MERGERINDEX
b)
1) SEARCH FOR SUBINDEX IN
Well if you do all the steps in one run, I guess optimizing once at the
end would be faster overall, but all you have to do is test it out and
time it, performance wise, I don't think that step 3 (OPTIMIZE) in
scenario (a) will really improve the performance of the new index merge.
my 2 cents