Re: Index Maintenance on Secondary Indices Marked as UNUSABLE

2016-08-15 Thread James Taylor
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]

Re: Index Maintenance on Secondary Indices Marked as UNUSABLE

2016-08-15 Thread James Taylor
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