Actually, the partial rebuild would need to work differently than I
mentioned to handle the case where rows are deleted from the table while
the index is disabled. See my comment here[1] for a pointer to some code
that handles this correctly.
[1]
Hi Julian,
Yes, marking an index as UNUSABLE simply means it won't be considered at
query time. It will still be maintained. If you DISABLE it, then you won't
be hit with the maintenance cost, but we don't have a mechanism to
partially rebuild it. See PHOENIX-2890 and the WIP patch. In theory, if