James Taylor created PHOENIX-4557:
-------------------------------------

             Summary: Move index state related columns to their own table
                 Key: PHOENIX-4557
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4557
             Project: Phoenix
          Issue Type: Improvement
            Reporter: James Taylor


To prevent full table scans on SYSTEM.CATALOG to determine out-of-sync indexes, 
we should factor out any state related information and put this into a 
SYSTEM.INDEX_STATE table instead. The table would only contain rows for tables 
that are in an invalid/unexpected state. Since the row count would be expected 
to be very low, a full table scan over this table would be tolerable. We'd need 
to join to this table when we send the PTable back from the server to the 
client.




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to